DBA Data[Home] [Help]

APPS.OE_CNCL_ORDER_IMPORT_PVT dependencies on OE_PRICE_ADJS_IFACE_ALL

Line 554: FROM oe_price_adjs_iface_all

550: , nvl( CHANGE_REASON_TEXT, FND_API.G_MISS_CHAR)
551: , nvl( PRICING_PHASE_ID, FND_API.G_MISS_NUM)
552: , nvl( ADJUSTED_AMOUNT, FND_API.G_MISS_NUM)
553: -- Price Adjustment related changes bug# 1220921 (End)
554: FROM oe_price_adjs_iface_all
555: WHERE order_source_id = l_order_source_id
556: AND orig_sys_document_ref = l_orig_sys_document_ref
557: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
558: = nvl(l_sold_to_org_id, FND_API.G_MISS_NUM)

Line 1081: FROM oe_price_adjs_iface_all

1077: , nvl( PRICING_PHASE_ID, FND_API.G_MISS_NUM)
1078: , nvl( ADJUSTED_AMOUNT, FND_API.G_MISS_NUM)
1079: , nvl( ORIG_SYS_LINE_REF, FND_API.G_MISS_CHAR)
1080: -- Price Adjustment related changes bug# 1220921 (End)
1081: FROM oe_price_adjs_iface_all
1082: WHERE order_source_id = l_order_source_id
1083: AND orig_sys_document_ref = l_orig_sys_document_ref
1084: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
1085: = nvl(l_sold_to_org_id, FND_API.G_MISS_NUM)