DBA Data[Home] [Help]

APPS.GML_RCV_DIR_RCPT_APIS dependencies on RCV_SHIPMENT_LINES

Line 1266: RCV_SHIPMENT_LINES RSL,

1262: NULL PROJECT_ID,
1263: NULL TASK_ID
1264: FROM
1265: RCV_SHIPMENT_HEADERS RSH,
1266: RCV_SHIPMENT_LINES RSL,
1267: PO_REQUISITION_HEADERS PORH,
1268: PO_REQUISITION_LINES PORL,
1269: MTL_SYSTEM_ITEMS MSI,
1270: MTL_SYSTEM_ITEMS MSI1,

Line 1448: -- Get the transfer_cost_group_id from rcv_shipment_lines

1444: l_progress := '68';
1445:
1446:
1447: l_rcv_transaction_rec.rcv_shipment_line_id := l_rcpt_match_table_detail(match_result_count).shipment_line_id;
1448: -- Get the transfer_cost_group_id from rcv_shipment_lines
1449: BEGIN
1450: SELECT cost_group_id
1451: INTO l_rcv_transaction_rec.transfer_cost_group_id
1452: FROM rcv_shipment_lines

Line 1452: FROM rcv_shipment_lines

1448: -- Get the transfer_cost_group_id from rcv_shipment_lines
1449: BEGIN
1450: SELECT cost_group_id
1451: INTO l_rcv_transaction_rec.transfer_cost_group_id
1452: FROM rcv_shipment_lines
1453: WHERE shipment_line_id = l_rcv_transaction_rec.rcv_shipment_line_id;
1454: EXCEPTION
1455: WHEN OTHERS THEN
1456: l_rcv_transaction_rec.transfer_cost_group_id := NULL;

Line 2185: RCV_SHIPMENT_LINES RSL,

2181: pod.rate_date CURRENCY_CONVERSION_DATE_POD,
2182: pod.project_id PROJECT_ID,
2183: pod.task_id TASK_ID
2184: FROM
2185: RCV_SHIPMENT_LINES RSL,
2186: RCV_SHIPMENT_HEADERS RSH,
2187: PO_HEADERS POH,
2188: PO_LINE_LOCATIONS POLL,
2189: PO_LINES POL,

Line 2349: RCV_SHIPMENT_LINES RSL,

2345: TO_NUMBER(NULL) PROJECT_ID,
2346: TO_NUMBER(NULL) TASK_ID
2347: FROM
2348: RCV_SHIPMENT_HEADERS RSH,
2349: RCV_SHIPMENT_LINES RSL,
2350: PO_REQUISITION_HEADERS PORH,
2351: PO_REQUISITION_LINES PORL,
2352: MTL_SYSTEM_ITEMS MSI,
2353: MTL_SYSTEM_ITEMS MSI1,