[Home] [Help]
294:
295: l_from_str := ' FROM rcv_supply rs,';
296: l_from_str := l_from_str || ' rcv_transactions rt,';
297: l_from_str := l_from_str || ' rcv_shipment_lines rsl,';
298: l_from_str := l_from_str || ' rcv_shipment_headers rsh';
299:
300: l_where_str := ' WHERE rs.supply_source_id = rt.transaction_id';
301: l_where_str := l_where_str || ' AND rs.to_organization_id = :org_id';
302: l_where_str := l_where_str || ' AND rs.supply_type_code = ''RECEIVING''';
925: IF (p_receipt_number IS NOT NULL) THEN
926: l_receipt_used := 1;
927: l_where_str := l_where_str||' AND mol.inventory_item_id';
928: l_where_str := l_where_str||' IN (SELECT rsl.item_id';
929: l_where_str := l_where_str||' FROM rcv_shipment_lines rsl,rcv_shipment_headers rsh';
930: l_where_str := l_where_str||' WHERE rsh.receipt_num = :receipt_num';
931: l_where_str := l_where_str||' AND rsh.shipment_header_id = rsl.shipment_header_id)';
932: ELSIF (p_document_type = 'PO') THEN
933: IF (p_document_id IS NOT NULL AND p_document_line_id IS NOT NULL) THEN
997: ELSE
998: IF (p_document_type = 'ASN') THEN
999: l_where_str := l_where_str||' AND mol.inventory_item_id';
1000: l_where_str := l_where_str||' IN (SELECT rs.item_id';
1001: l_where_str := l_where_str||' FROM rcv_supply rs,rcv_shipment_headers rsh';
1002: l_where_str := l_where_str||' WHERE rsh.asn_type IN (''ASN'',''ASBN'')';
1003: l_where_str := l_where_str||' AND rsh.shipment_num is not null';
1004: l_where_str := l_where_str||' AND rs.shipment_header_id = rsh.shipment_header_id';
1005: l_where_str := l_where_str||' AND rs.to_organization_id = :org_id)';
1005: l_where_str := l_where_str||' AND rs.to_organization_id = :org_id)';
1006: ELSE
1007: l_where_str := l_where_str||' AND mol.inventory_item_id';
1008: l_where_str := l_where_str||' IN (SELECT rs.item_id';
1009: l_where_str := l_where_str||' FROM rcv_supply rs,rcv_shipment_headers rsh';
1010: l_where_str := l_where_str||' WHERE rsh.asn_type NOT IN (''ASN'',''ASBN'')';
1011: l_where_str := l_where_str||' AND rsh.shipment_num is not null';
1012: l_where_str := l_where_str||' AND rs.to_organization_id = :org_id';
1013: l_where_str := l_where_str||' AND rs.shipment_header_id = rsh.shipment_header_id';
1375: IF l_material_rec.reference_id IS NOT NULL THEN
1376: BEGIN
1377: SELECT rsh.shipment_header_id, rsl.shipment_line_id, rsl.requisition_line_id, rsh.shipment_num, rsh.asn_type, rsh.receipt_source_code, rsh.ship_to_org_id, rsl.line_num, rsh.receipt_num, rsh.vendor_id, rsl.from_organization_id
1378: INTO l_shipment_header_id, l_shipment_line_id, l_req_line_id, l_shipment_num, l_asn_type, l_receipt_source_code, l_ship_to_org_id, l_line_num, l_receipt_num, l_vendor_id, l_src_org_id
1379: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh
1380: WHERE rsh.shipment_header_id = rsl.shipment_header_id
1381: AND rsl.shipment_line_id = l_material_rec.reference_id;
1382: EXCEPTION
1383: WHEN no_data_found THEN
1438: BEGIN
1439: SELECT rsh.shipment_header_id, rsh.shipment_num, rsh.receipt_num,rsh.vendor_id
1440: ,rsl.shipment_line_id, rsl.line_num,rsl.from_organization_id
1441: INTO l_material_rec.document_id, l_material_rec.document_number, l_receipt_num, l_vendor_id,l_shipment_line_id, l_line_num, l_src_org_id
1442: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh
1443: WHERE rsh.shipment_header_id = rsl.shipment_header_id
1444: AND rsl.shipment_line_id = l_material_rec.reference_id;
1445: EXCEPTION
1446: WHEN no_data_found THEN
1494: ELSE
1495: IF (l_material_rec.reference_id IS NOT NULL) THEN
1496: BEGIN
1497: SELECT rsh.vendor_id INTO l_material_rec.vendor_id
1498: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh
1499: WHERE rsh.shipment_header_id = rsl.shipment_header_id
1500: AND rsl.shipment_line_id = l_material_rec.reference_id;
1501: EXCEPTION
1502: WHEN no_data_found THEN