APPS.OE_ORDER_IMPORT_PVT dependencies on OE_ORDER_LINES_ALL

Line 3660: FROM OE_ORDER_LINES_ALL

3656: IF l_line_rec.calculate_price_flag IS NULL or l_line_rec.calculate_price_flag = FND_API.G_MISS_CHAR then
3657: --populate calculate_price_flag from lines table
3658: SELECT calculate_price_flag
3659: INTO l_line_rec.calculate_price_flag
3660: FROM OE_ORDER_LINES_ALL
3661: WHERE orig_sys_document_ref = l_line_rec.orig_sys_document_ref
3662: AND orig_sys_line_ref = l_line_rec.orig_sys_line_ref;
3663:
3664: IF l_debug_level > 0 THEN

Line 3675: FROM OE_ORDER_LINES_ALL

3671: AND (l_line_rec.unit_list_price is null or l_line_rec.unit_list_price = FND_API.G_MISS_NUM)
3672: THEN
3673: SELECT unit_selling_price,unit_list_price
3674: INTO l_line_rec.unit_selling_price,l_line_rec.unit_list_price
3675: FROM OE_ORDER_LINES_ALL
3676: WHERE orig_sys_document_ref = l_line_rec.orig_sys_document_ref
3677: AND orig_sys_line_ref = l_line_rec.orig_sys_line_ref;
3678:
3679: IF l_debug_level > 0 THEN

Line 3694: FROM OE_ORDER_LINES_ALL

3690: AND (l_line_rec.unit_list_price is null or l_line_rec.unit_list_price = FND_API.G_MISS_NUM)
3691: THEN
3692: SELECT unit_selling_price,unit_list_price
3693: INTO l_line_rec.unit_selling_price,l_line_rec.unit_list_price
3694: FROM OE_ORDER_LINES_ALL
3695: WHERE orig_sys_document_ref = l_line_rec.orig_sys_document_ref
3696: AND orig_sys_line_ref = l_line_rec.orig_sys_line_ref;
3697:
3698: IF l_debug_level > 0 THEN

Line 3709: FROM OE_ORDER_LINES_ALL

3705: IF l_line_rec.calculate_price_flag IS NULL or l_line_rec.calculate_price_flag = FND_API.G_MISS_CHAR then
3706: --populate calculate_price_flag from lines table
3707: SELECT calculate_price_flag
3708: INTO l_line_rec.calculate_price_flag
3709: FROM OE_ORDER_LINES_ALL
3710: WHERE orig_sys_document_ref = l_line_rec.orig_sys_document_ref
3711: AND orig_sys_line_ref = l_line_rec.orig_sys_line_ref
3712: AND orig_sys_shipment_ref = l_line_rec.orig_sys_shipment_ref;
3713:

Line 3725: FROM OE_ORDER_LINES_ALL

3721: AND (l_line_rec.unit_list_price is null or l_line_rec.unit_list_price = FND_API.G_MISS_NUM)
3722: THEN
3723: SELECT unit_selling_price,unit_list_price
3724: INTO l_line_rec.unit_selling_price,l_line_rec.unit_list_price
3725: FROM OE_ORDER_LINES_ALL
3726: WHERE orig_sys_document_ref = l_line_rec.orig_sys_document_ref
3727: AND orig_sys_line_ref = l_line_rec.orig_sys_line_ref
3728: AND orig_sys_shipment_ref = l_line_rec.orig_sys_shipment_ref;
3729:

Line 3745: FROM OE_ORDER_LINES_ALL

3741: AND (l_line_rec.unit_list_price is null or l_line_rec.unit_list_price = FND_API.G_MISS_NUM)
3742: THEN
3743: SELECT unit_selling_price,unit_list_price
3744: INTO l_line_rec.unit_selling_price,l_line_rec.unit_list_price
3745: FROM OE_ORDER_LINES_ALL
3746: WHERE orig_sys_document_ref = l_line_rec.orig_sys_document_ref
3747: AND orig_sys_line_ref = l_line_rec.orig_sys_line_ref
3748: AND orig_sys_shipment_ref = l_line_rec.orig_sys_shipment_ref;
3749: