DBA Data[Home] [Help]

APPS.INV_MGD_MVT_STATS_PROC dependencies on OE_ORDER_HEADERS_ALL

Line 1750: FROM oe_order_headers_all

1746: transactional_curr_code
1747: , conversion_rate
1748: , conversion_type_code
1749: , conversion_rate_date
1750: FROM oe_order_headers_all
1751: WHERE header_id = l_movement_transaction2.order_header_id;
1752:
1753: CURSOR bill_to_site IS
1754: SELECT

Line 4984: FROM OE_ORDER_HEADERS_ALL ooha

4980: AND l_movement_transaction.order_number IS null) Then
4981: Begin
4982: SELECT ooha.order_number order_number
4983: INTO l_movement_transaction.order_number
4984: FROM OE_ORDER_HEADERS_ALL ooha
4985: WHERE ooha.header_id= l_movement_transaction.order_header_id;
4986: EXCEPTION
4987: WHEN OTHERS THEN
4988: NULL;

Line 5478: was booked - sold_from_org_id from OE_ORDER_HEADERS_ALL */

5474: NVL(l_subinv_terr_code, l_org_terr_code);
5475: l_process_flag := 'Y';
5476:
5477: /* The dispatch territory code will be the country where the RMA
5478: was booked - sold_from_org_id from OE_ORDER_HEADERS_ALL */
5479: l_movement_transaction.dispatch_territory_code := l_sold_from_org_code;
5480: /* triangulation country would be the country where the RMA was created / booked */
5481: l_movement_transaction.triangulation_country_code := l_sold_from_org_code;
5482: