APPS.OE_ORDER_IMPORT_PVT dependencies on OE_ORDER_LINES_ALL

Line 3630: FROM OE_ORDER_LINES_ALL

3626: IF l_line_rec.calculate_price_flag IS NULL or l_line_rec.calculate_price_flag = FND_API.G_MISS_CHAR then
3627: --populate calculate_price_flag from lines table
3628: SELECT calculate_price_flag
3629: INTO l_line_rec.calculate_price_flag
3630: FROM OE_ORDER_LINES_ALL
3631: WHERE orig_sys_document_ref = l_line_rec.orig_sys_document_ref
3632: AND orig_sys_line_ref = l_line_rec.orig_sys_line_ref;
3633:
3634: IF l_debug_level > 0 THEN

Line 3645: FROM OE_ORDER_LINES_ALL

3641: AND (l_line_rec.unit_list_price is null or l_line_rec.unit_list_price = FND_API.G_MISS_NUM)
3642: THEN
3643: SELECT unit_selling_price,unit_list_price
3644: INTO l_line_rec.unit_selling_price,l_line_rec.unit_list_price
3645: FROM OE_ORDER_LINES_ALL
3646: WHERE orig_sys_document_ref = l_line_rec.orig_sys_document_ref
3647: AND orig_sys_line_ref = l_line_rec.orig_sys_line_ref;
3648:
3649: IF l_debug_level > 0 THEN

Line 3664: FROM OE_ORDER_LINES_ALL

3660: AND (l_line_rec.unit_list_price is null or l_line_rec.unit_list_price = FND_API.G_MISS_NUM)
3661: THEN
3662: SELECT unit_selling_price,unit_list_price
3663: INTO l_line_rec.unit_selling_price,l_line_rec.unit_list_price
3664: FROM OE_ORDER_LINES_ALL
3665: WHERE orig_sys_document_ref = l_line_rec.orig_sys_document_ref
3666: AND orig_sys_line_ref = l_line_rec.orig_sys_line_ref;
3667:
3668: IF l_debug_level > 0 THEN

Line 3679: FROM OE_ORDER_LINES_ALL

3675: IF l_line_rec.calculate_price_flag IS NULL or l_line_rec.calculate_price_flag = FND_API.G_MISS_CHAR then
3676: --populate calculate_price_flag from lines table
3677: SELECT calculate_price_flag
3678: INTO l_line_rec.calculate_price_flag
3679: FROM OE_ORDER_LINES_ALL
3680: WHERE orig_sys_document_ref = l_line_rec.orig_sys_document_ref
3681: AND orig_sys_line_ref = l_line_rec.orig_sys_line_ref
3682: AND orig_sys_shipment_ref = l_line_rec.orig_sys_shipment_ref;
3683:

Line 3695: FROM OE_ORDER_LINES_ALL

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

Line 3715: FROM OE_ORDER_LINES_ALL

3711: AND (l_line_rec.unit_list_price is null or l_line_rec.unit_list_price = FND_API.G_MISS_NUM)
3712: THEN
3713: SELECT unit_selling_price,unit_list_price
3714: INTO l_line_rec.unit_selling_price,l_line_rec.unit_list_price
3715: FROM OE_ORDER_LINES_ALL
3716: WHERE orig_sys_document_ref = l_line_rec.orig_sys_document_ref
3717: AND orig_sys_line_ref = l_line_rec.orig_sys_line_ref
3718: AND orig_sys_shipment_ref = l_line_rec.orig_sys_shipment_ref;
3719: