Wednesday, October 19, 2016

Joins


Joins


FROM

 HZ_PARTIES PARTY,
  HZ_CUST_ACCOUNTS CUST_ACCT,
  OE_ORDER_LINES_ALL LINE,
  OE_AGREEMENTS AGREE,
  OE_TRANSACTION_TYPES_TL lt,
  QP_LIST_HEADERS_TL PL,
  MTL_SYSTEM_ITEMS_VL ITEMS,
  MTL_UNITS_OF_MEASURE_TL UOM,


WHERE

LINE.line_type_id                        = lt.transaction_type_id
AND lt.language                                = userenv('LANG')
AND LINE.agreement_id                          = agree.agreement_id(+)
AND LINE.price_list_id                         = pl.list_header_id(+)
AND pl.language(+)                             = userenv('LANG')
AND LINE.sold_to_org_id                        = cust_acct.cust_account_id(+)
AND PARTY.party_id(+)                          = cust_acct.party_id
AND LINE.inventory_item_id                     = items.inventory_item_id(+)
AND items.organization_id                      =ITEMS.organization_id
AND LINE.order_quantity_uom                    = uom.uom_code(+)
AND UOM.language(+)                            = userenv('LANG')

No comments:

Post a Comment