DBA Data[Home] [Help]

APPS.GMI_AUTO_ALLOC_BATCH_PKG dependencies on OE_ORDER_LINES_ALL

Line 691: , ship_to_org_id oe_order_lines_all.SHIP_TO_ORG_ID%TYPE

687: , order_qty1 OP_ORDR_DTL.ORDER_QTY1%TYPE
688: , order_qty2 OP_ORDR_DTL.ORDER_QTY2%TYPE
689: , order_um1 OP_ORDR_DTL.ORDER_UM1%TYPE
690: , order_um2 OP_ORDR_DTL.ORDER_UM2%TYPE
691: , ship_to_org_id oe_order_lines_all.SHIP_TO_ORG_ID%TYPE
692: , of_cust_id oe_order_lines_all.sold_to_org_id%TYPE
693: , org_id oe_order_lines_all.org_id%TYPE
694: , trans_date IC_TRAN_PND.TRANS_DATE%TYPE
695: , user_id FND_USER.USER_ID%TYPE

Line 692: , of_cust_id oe_order_lines_all.sold_to_org_id%TYPE

688: , order_qty2 OP_ORDR_DTL.ORDER_QTY2%TYPE
689: , order_um1 OP_ORDR_DTL.ORDER_UM1%TYPE
690: , order_um2 OP_ORDR_DTL.ORDER_UM2%TYPE
691: , ship_to_org_id oe_order_lines_all.SHIP_TO_ORG_ID%TYPE
692: , of_cust_id oe_order_lines_all.sold_to_org_id%TYPE
693: , org_id oe_order_lines_all.org_id%TYPE
694: , trans_date IC_TRAN_PND.TRANS_DATE%TYPE
695: , user_id FND_USER.USER_ID%TYPE
696: , user_name FND_USER.USER_NAME%TYPE

Line 693: , org_id oe_order_lines_all.org_id%TYPE

689: , order_um1 OP_ORDR_DTL.ORDER_UM1%TYPE
690: , order_um2 OP_ORDR_DTL.ORDER_UM2%TYPE
691: , ship_to_org_id oe_order_lines_all.SHIP_TO_ORG_ID%TYPE
692: , of_cust_id oe_order_lines_all.sold_to_org_id%TYPE
693: , org_id oe_order_lines_all.org_id%TYPE
694: , trans_date IC_TRAN_PND.TRANS_DATE%TYPE
695: , user_id FND_USER.USER_ID%TYPE
696: , user_name FND_USER.USER_NAME%TYPE
697: );

Line 1305: FROM oe_order_lines_all oel

1301: , oel.line_number + (oel.shipment_number / 10)
1302: , oel.org_id
1303: , oel.schedule_ship_date
1304: , oel.header_id
1305: FROM oe_order_lines_all oel
1306: WHERE oel.line_id = p_wdd_line.source_line_id;
1307:
1308: l_oe_line c_customer_and_so_info%rowtype;
1309: CURSOR c_user IS