APPS.RCV_INT_ORDER_PP_PVT dependencies on RCV_SHIPMENT_LINES

Line 738: rcv_shipment_lines rsl,

734: rsl.requisition_line_id requisition_line_id,
735: rsl.po_line_location_id po_line_location_id,
736: rsl.employee_id employee_id
737: FROM rcv_shipment_headers rsh,
738: rcv_shipment_lines rsl,
739: po_requisition_lines_all porl
740: -- Following 2 lines are commented out for Bugfix 5201155
741: -- WHERE rsh.shipment_header_id = NVL(v_shipment_header_id, rsh.shipment_header_id)
742: -- AND NVL(rsh.shipment_num, '0') = NVL(v_shipment_num, NVL(rsh.shipment_num, '0'))

Line 763: rcv_shipment_lines rsl,

759: v_ship_from_org_id NUMBER
760: ) IS
761: SELECT COUNT(*) AS line_count
762: FROM rcv_shipment_headers rsh,
763: rcv_shipment_lines rsl,
764: po_requisition_lines_all porl
765: -- Following 2 lines are commented out for Bugfix 5201155
766: -- WHERE rsh.shipment_header_id = NVL(v_shipment_header_id, rsh.shipment_header_id)
767: -- AND NVL(rsh.shipment_num, '0') = NVL(v_shipment_num, NVL(rsh.shipment_num, '0'))

Line 875: rcv_shipment_lines rsl

871: BEGIN
872: SELECT distinct rsh.shipment_header_id
873: INTO l_shipment_header_id
874: FROM rcv_shipment_headers rsh,
875: rcv_shipment_lines rsl
876: WHERE shipment_num = temp_cascaded_table(current_n).shipment_num
877: AND rsh.shipment_header_id = rsl.shipment_header_id
878: AND rsl.to_organization_id = NVL(temp_cascaded_table(current_n).to_organization_id, to_organization_id)
879: AND rsl.from_organization_id = NVL(temp_cascaded_table(current_n).from_organization_id, from_organization_id)

Line 1608: FROM rcv_shipment_lines rsl

1604: AND receipt_source_code = 'INTERNAL ORDER';
1605:
1606: SELECT rsl.shipment_line_id
1607: INTO l_shipment_line_id
1608: FROM rcv_shipment_lines rsl
1609: WHERE rsl.shipment_header_id = l_shipment_header_id
1610: AND rsl.item_description = x_cascaded_table(n).item_description
1611: AND ROWNUM = 1;
1612: ELSE

Line 1639: FROM rcv_shipment_lines rsl

1635: l_to_organization_id,
1636: l_item_id,
1637: l_category_id,
1638: l_employee_id
1639: FROM rcv_shipment_lines rsl
1640: WHERE rsl.shipment_header_id = l_shipment_header_id
1641: AND rsl.shipment_line_id = l_shipment_line_id;
1642:
1643: x_cascaded_table(n).requisition_line_id := NVL(x_cascaded_table(n).requisition_line_id, l_requisition_line_id);

Line 1681: from rcv_shipment_lines

1677:
1678: BEGIN
1679: select deliver_to_person_id
1680: into l_deliver_to_person_id
1681: from rcv_shipment_lines
1682: where shipment_line_id = x_cascaded_table(n).shipment_line_id;
1683:
1684: x_cascaded_table(n).deliver_to_person_id := l_deliver_to_person_id;
1685: IF (g_asn_debug = 'Y') THEN

Line 1702: from rcv_shipment_lines

1698:
1699: BEGIN
1700: select count(shipment_line_id)
1701: into l_rsl_count
1702: from rcv_shipment_lines
1703: where shipment_header_id = x_cascaded_table(n).shipment_header_id;
1704:
1705: IF (g_asn_debug = 'Y') THEN
1706: asn_debug.put_line('Inside rsh not null..l_rsl_count:'||l_rsl_count);

Line 1712: from rcv_shipment_lines

1708:
1709: IF l_rsl_count = 1 THEN
1710: select deliver_to_person_id
1711: into l_deliver_to_person_id
1712: from rcv_shipment_lines
1713: where shipment_header_id = x_cascaded_table(n).shipment_header_id;
1714: x_cascaded_table(n).deliver_to_person_id := l_deliver_to_person_id;
1715: IF (g_asn_debug = 'Y') THEN
1716: asn_debug.put_line('defaulted deliver_to_person_id as:'||l_deliver_to_person_id);