DBA Data[Home] [Help]

APPS.INV_MGD_MVT_STATS_PROC dependencies on OE_ORDER_HEADERS_ALL

Line 1671: FROM oe_order_headers_all

1667: transactional_curr_code
1668: , conversion_rate
1669: , conversion_type_code
1670: , conversion_rate_date
1671: FROM oe_order_headers_all
1672: WHERE header_id = l_movement_transaction2.order_header_id;
1673:
1674: CURSOR bill_to_site IS
1675: SELECT

Line 4621: FROM OE_ORDER_HEADERS_ALL ooha

4617: AND l_movement_transaction.order_number IS null) Then
4618: Begin
4619: SELECT ooha.order_number order_number
4620: INTO l_movement_transaction.order_number
4621: FROM OE_ORDER_HEADERS_ALL ooha
4622: WHERE ooha.header_id= l_movement_transaction.order_header_id;
4623: EXCEPTION
4624: WHEN OTHERS THEN
4625: NULL;

Line 4967: was booked - sold_from_org_id from OE_ORDER_HEADERS_ALL */

4963: NVL(l_subinv_terr_code, l_org_terr_code);
4964: l_process_flag := 'Y';
4965:
4966: /* The dispatch territory code will be the country where the RMA
4967: was booked - sold_from_org_id from OE_ORDER_HEADERS_ALL */
4968: l_movement_transaction.dispatch_territory_code := l_sold_from_org_code;
4969: /* triangulation country would be the country where the RMA was created / booked */
4970: l_movement_transaction.triangulation_country_code := l_sold_from_org_code;
4971: