APPS.RCV_INT_ORDER_PP_PVT dependencies on RCV_SHIPMENT_LINES

Line 781: rcv_shipment_lines rsl,

777: rsl.requisition_line_id requisition_line_id,
778: rsl.po_line_location_id po_line_location_id,
779: rsl.employee_id employee_id
780: FROM rcv_shipment_headers rsh,
781: rcv_shipment_lines rsl,
782: po_requisition_lines_all porl
783: -- Following 2 lines are commented out for Bugfix 5201155
784: -- WHERE rsh.shipment_header_id = NVL(v_shipment_header_id, rsh.shipment_header_id)
785: -- AND NVL(rsh.shipment_num, '0') = NVL(v_shipment_num, NVL(rsh.shipment_num, '0'))

Line 808: rcv_shipment_lines rsl,

804: v_shipment_line_id NUMBER -- Bug 8374257
805: ) IS
806: SELECT COUNT(*) AS line_count
807: FROM rcv_shipment_headers rsh,
808: rcv_shipment_lines rsl,
809: po_requisition_lines_all porl
810: -- Following 2 lines are commented out for Bugfix 5201155
811: -- WHERE rsh.shipment_header_id = NVL(v_shipment_header_id, rsh.shipment_header_id)
812: -- AND NVL(rsh.shipment_num, '0') = NVL(v_shipment_num, NVL(rsh.shipment_num, '0'))

Line 921: rcv_shipment_lines rsl

917: BEGIN
918: SELECT distinct rsh.shipment_header_id
919: INTO l_shipment_header_id
920: FROM rcv_shipment_headers rsh,
921: rcv_shipment_lines rsl
922: WHERE shipment_num = temp_cascaded_table(current_n).shipment_num
923: AND rsh.shipment_header_id = rsl.shipment_header_id
924: AND rsl.to_organization_id = NVL(temp_cascaded_table(current_n).to_organization_id, to_organization_id)
925: AND rsl.from_organization_id = NVL(temp_cascaded_table(current_n).from_organization_id, from_organization_id)

Line 1667: FROM rcv_shipment_lines rsl

1663: AND receipt_source_code = 'INTERNAL ORDER';
1664:
1665: SELECT rsl.shipment_line_id
1666: INTO l_shipment_line_id
1667: FROM rcv_shipment_lines rsl
1668: WHERE rsl.shipment_header_id = l_shipment_header_id
1669: AND rsl.item_description = x_cascaded_table(n).item_description
1670: AND ROWNUM = 1;
1671: ELSE

Line 1698: FROM rcv_shipment_lines rsl

1694: l_to_organization_id,
1695: l_item_id,
1696: l_category_id,
1697: l_employee_id
1698: FROM rcv_shipment_lines rsl
1699: WHERE rsl.shipment_header_id = l_shipment_header_id
1700: AND rsl.shipment_line_id = l_shipment_line_id;
1701:
1702: x_cascaded_table(n).requisition_line_id := NVL(x_cascaded_table(n).requisition_line_id, l_requisition_line_id);

Line 1744: from rcv_shipment_lines

1740:
1741: BEGIN
1742: select deliver_to_person_id
1743: into l_deliver_to_person_id
1744: from rcv_shipment_lines
1745: where shipment_line_id = x_cascaded_table(n).shipment_line_id;
1746:
1747: x_cascaded_table(n).deliver_to_person_id := l_deliver_to_person_id;
1748: IF (g_asn_debug = 'Y') THEN

Line 1765: from rcv_shipment_lines

1761:
1762: BEGIN
1763: select count(shipment_line_id)
1764: into l_rsl_count
1765: from rcv_shipment_lines
1766: where shipment_header_id = x_cascaded_table(n).shipment_header_id;
1767:
1768: IF (g_asn_debug = 'Y') THEN
1769: asn_debug.put_line('Inside rsh not null..l_rsl_count:'||l_rsl_count);

Line 1775: from rcv_shipment_lines

1771:
1772: IF l_rsl_count = 1 THEN
1773: select deliver_to_person_id
1774: into l_deliver_to_person_id
1775: from rcv_shipment_lines
1776: where shipment_header_id = x_cascaded_table(n).shipment_header_id;
1777: x_cascaded_table(n).deliver_to_person_id := l_deliver_to_person_id;
1778: IF (g_asn_debug = 'Y') THEN
1779: asn_debug.put_line('defaulted deliver_to_person_id as:'||l_deliver_to_person_id);