DBA Data[Home] [Help]

APPS.OE_CONFIG dependencies on SO_PRICE_LISTS

Line 96: FROM SO_PRICE_LISTS PRI

92: prc_attr13 VARCHAR2,
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

Line 98: , SO_PRICE_LISTS SEC

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
102: AND PRL.PRICE_LIST_ID (+) +0 = PRI.PRICE_LIST_ID