DBA Data[Home] [Help]

APPS.OE_CONFIG dependencies on SO_PRICE_LIST_LINES

Line 97: , SO_PRICE_LIST_LINES PRL

93: prc_attr14 VARCHAR2,
94: prc_attr15 VARCHAR2) IS
95: SELECT NVL(PRL.LIST_PRICE,SEL.LIST_PRICE)
96: FROM SO_PRICE_LISTS PRI
97: , SO_PRICE_LIST_LINES PRL
98: , SO_PRICE_LISTS SEC
99: , SO_PRICE_LIST_LINES SEL
100: WHERE PRL.INVENTORY_ITEM_ID (+)= component_item_id
101: AND PRL.UNIT_CODE (+)= primary_uom_code

Line 99: , SO_PRICE_LIST_LINES SEL

95: SELECT NVL(PRL.LIST_PRICE,SEL.LIST_PRICE)
96: FROM SO_PRICE_LISTS PRI
97: , SO_PRICE_LIST_LINES PRL
98: , SO_PRICE_LISTS SEC
99: , SO_PRICE_LIST_LINES SEL
100: WHERE PRL.INVENTORY_ITEM_ID (+)= component_item_id
101: AND PRL.UNIT_CODE (+)= primary_uom_code
102: AND PRL.PRICE_LIST_ID (+) +0 = PRI.PRICE_LIST_ID
103: AND TRUNC(SYSDATE) BETWEEN NVL(PRL.START_DATE_ACTIVE(+),TRUNC(SYSDATE))