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