[Home] [Help]
608: rsh.bill_of_lading,
609: rsh.waybill_airbill_num,
610: rsh.freight_carrier_code
611: FROM
612: rcv_shipment_headers rsh,
613: rcv_shipment_lines rsl,
614: rcv_supply ms,
615: rcv_transactions rt,
616: org_organization_definitions ood
651: sh.packing_slip,
652: sh.bill_of_lading,
653: sh.waybill_airbill_num,
654: sh.freight_carrier_code
655: FROM rcv_shipment_headers sh,
656: rcv_shipment_lines sl
657: WHERE sh.shipment_num IS NOT NULL
658: AND sh.shipment_header_id = sl.shipment_header_id
659: AND sl.to_organization_id = p_organization_id
681: sh.packing_slip,
682: sh.bill_of_lading,
683: sh.waybill_airbill_num,
684: sh.freight_carrier_code
685: FROM rcv_shipment_headers sh,
686: rcv_shipment_lines sl
687: WHERE sh.shipment_num IS NOT NULL
688: AND sh.shipment_header_id = sl.shipment_header_id
689: AND sl.to_organization_id = p_organization_id
716: rsh.freight_carrier_code
717: FROM RCV_SUPPLY RSUP,
718: RCV_SHIPMENT_LINES RSL,
719: RCV_TRANSACTIONS RT,
720: RCV_SHIPMENT_HEADERS RSH,
721: PO_LOOKUP_CODES PLC,
722: PO_LINE_LOCATIONS_ALL PLL,
723: HR_ALL_ORGANIZATION_UNITS_TL OOD
724: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
863: AND prh.segment1 LIKE (p_requisition_num)
864: AND exists
865: (SELECT 1
866: FROM rcv_shipment_lines rsl,
867: rcv_shipment_headers rsh,
868: rcv_transactions_v rtv
869: WHERE rsl.requisition_line_id = prl.requisition_line_id
870: AND rsh.shipment_header_id = rsl.shipment_header_id
871: AND rtv.shipment_header_id = rsh.shipment_header_id
902: sh.expected_receipt_date,
903: Decode(sh.receipt_source_code,'VENDOR',sh.vendor_id, sl.from_organization_id) from_organization_id,
904: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id,sl.from_organization_id),1,80) organization_name,
905: Decode(sh.receipt_source_code,'VENDOR','Vendor','Organization')
906: FROM rcv_shipment_headers sh,
907: rcv_shipment_lines sl
908: WHERE sh.packing_slip IS NOT NULL
909: AND sh.shipment_header_id = sl.shipment_header_id
910: AND sl.to_organization_id = p_organization_id
922: sh.expected_receipt_date,
923: Decode(sh.receipt_source_code,'VENDOR',sh.vendor_id, sl.from_organization_id) from_organization_id,
924: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id,sl.from_organization_id),1,80) organization_name,
925: Decode(sh.receipt_source_code,'VENDOR','Vendor','Organization')
926: FROM rcv_shipment_headers sh,
927: rcv_shipment_lines sl
928: WHERE sh.packing_slip IS NOT NULL
929: AND sh.shipment_header_id = sl.shipment_header_id
930: AND sl.to_organization_id = p_organization_id
953: , rt.po_release_id --bug6594996 add PO release header ID associated with the receip
954: , ms.from_organization_id -- bug #6917248
955: FROM rcv_supply ms
956: , rcv_transactions rt
957: , rcv_shipment_headers rsh
958: , rcv_shipment_lines rsl
959: , mtl_parameters mp
960: WHERE rsh.shipment_header_id = ms.shipment_header_id
961: AND rsh.shipment_header_id = rt.shipment_header_id
1110: , null -- bug # 6917248
1111: , rsup.from_organization_id -- bug # 6917248
1112: FROM RCV_SUPPLY RSUP,
1113: RCV_TRANSACTIONS RT,
1114: RCV_SHIPMENT_HEADERS RSH,
1115: RCV_SHIPMENT_LINES RSL,
1116: PO_LOOKUP_CODES PLC,
1117: PO_LINE_LOCATIONS_ALL PLL,
1118: mtl_parameters mp --BUG 5166887
2090: sh.freight_carrier_code FIELD13,
2091: lookup_code FIELD14,
2092: NULL FIELD15 --
2093: FROM fnd_lookup_values_vl flv,
2094: rcv_shipment_headers sh,
2095: rcv_shipment_lines sl
2096: WHERE flv.lookup_code = 'INTSHIP'
2097: AND flv.lookup_type = 'DOC_TYPE'
2098: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2138: sh.freight_carrier_code FIELD13,
2139: lookup_code FIELD14,
2140: NULL FIELD15 --
2141: FROM fnd_lookup_values_vl flv,
2142: rcv_shipment_headers sh,
2143: rcv_shipment_lines sl
2144: WHERE flv.lookup_code = 'ASN'
2145: AND flv.lookup_type = 'DOC_TYPE'
2146: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2181: sh.freight_carrier_code FIELD13,
2182: lookup_code FIELD14,
2183: NULL FIELD15 --
2184: FROM fnd_lookup_values_vl flv,
2185: rcv_shipment_headers sh,
2186: rcv_shipment_lines sl
2187: WHERE flv.lookup_code = 'ASN'
2188: AND flv.lookup_type = 'DOC_TYPE'
2189: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2225: sh.freight_carrier_code FIELD13,
2226: lookup_code FIELD14 ,
2227: NULL FIELD15 --
2228: FROM fnd_lookup_values_vl flv,
2229: rcv_shipment_headers sh,
2230: rcv_shipment_lines sl
2231: WHERE flv.lookup_code = 'ASN'
2232: AND flv.lookup_type = 'DOC_TYPE'
2233: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2269: sh.freight_carrier_code FIELD13,
2270: lookup_code FIELD14,
2271: NULL FIELD15 --
2272: FROM fnd_lookup_values_vl flv,
2273: rcv_shipment_headers sh,
2274: rcv_shipment_lines sl
2275: WHERE flv.lookup_code = 'LCM'
2276: AND flv.lookup_type = 'DOC_TYPE'
2277: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2312: sh.freight_carrier_code FIELD13,
2313: lookup_code FIELD14,
2314: NULL FIELD15 --
2315: FROM fnd_lookup_values_vl flv,
2316: rcv_shipment_headers sh,
2317: rcv_shipment_lines sl
2318: WHERE flv.lookup_code = 'LCM'
2319: AND flv.lookup_type = 'DOC_TYPE'
2320: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2356: sh.freight_carrier_code FIELD13,
2357: lookup_code FIELD14 ,
2358: NULL FIELD15 --
2359: FROM fnd_lookup_values_vl flv,
2360: rcv_shipment_headers sh,
2361: rcv_shipment_lines sl
2362: WHERE flv.lookup_code = 'LCM'
2363: AND flv.lookup_type = 'DOC_TYPE'
2364: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2728: sh.freight_carrier_code FIELD13,
2729: lookup_code FIELD14,
2730: NULL FIELD15 --
2731: FROM fnd_lookup_values_vl flv,
2732: rcv_shipment_headers sh,
2733: rcv_shipment_lines sl
2734: WHERE flv.lookup_code = 'INTSHIP'
2735: AND flv.lookup_type = 'DOC_TYPE'
2736: AND nvl(flv.start_date_active, SYSDATE )<= SYSDATE
2773: sh.freight_carrier_code FIELD13,
2774: lookup_code FIELD14,
2775: NULL FIELD15 --
2776: FROM fnd_lookup_values_vl flv,
2777: rcv_shipment_headers sh,
2778: rcv_shipment_lines sl
2779: WHERE flv.lookup_code = 'ASN'
2780: AND flv.lookup_type = 'DOC_TYPE'
2781: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2827: sh.freight_carrier_code FIELD13,
2828: lookup_code FIELD14,
2829: NULL FIELD15 --
2830: FROM fnd_lookup_values_vl flv,
2831: rcv_shipment_headers sh,
2832: rcv_shipment_lines sl
2833: WHERE flv.lookup_code = 'LCM'
2834: AND flv.lookup_type = 'DOC_TYPE'
2835: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
3159: , po_distributions_all pda
3160: , wip_osp_jobs_val_v wojv
3161: , wip_osp_lines_val_v wolv
3162: , wip_osp_operations_val_v woov
3163: , rcv_shipment_headers shh
3164: , rcv_shipment_lines shl
3165: WHERE shh.shipment_header_id = p_shipment_header_id
3166: AND shl.shipment_header_id = shh.shipment_header_id
3167: AND phl.po_header_id =shl.po_header_id
6756: DECODE (p_reqHeaderID,to_char(null),' ',p_shipmentHeaderID) -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
6757: from wms_lpn_contents wlc ,
6758: mtl_system_items_vl msn, /* Bug 5581528 */
6759: rcv_shipment_lines rsl,
6760: rcv_shipment_headers rsh /* Added for Bug9257750 */
6761: WHERE msn.organization_id = p_Organization_Id
6762: and wlc.parent_lpn_id = l_from_lpn_id
6763: and wlc.inventory_item_id = rsl.item_id
6764: and msn.concatenated_segments like p_concatenated_segments||l_append
6831: from wms_lpn_contents wlc
6832: ,po_lines_trx_v pol -- CLM project, bug 9403291
6833: ,mtl_system_items_vl msi /* Bug 5581528 */
6834: ,rcv_shipment_lines rsl
6835: ,rcv_shipment_headers rsh /* Added for Bug9257750 */
6836: where msi.organization_id = p_Organization_Id
6837: and wlc.parent_lpn_id = l_from_lpn_id
6838: and wlc.inventory_item_id = msi.inventory_item_id
6839: and pol.vendor_product_num like p_concatenated_segments
6929: p_shipmentHeaderID) -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
6930: from po_lines_trx_v pol -- CLM project, bug 9403291
6931: , mtl_units_of_measure mum
6932: ,rcv_shipment_lines rsl
6933: , rcv_shipment_headers rsh /* Added for Bug9257750 */
6934: -- Bug 2619063, 2614016
6935: -- Modified to select the base uom for the uom class defined on po.
6936: where mum.uom_class = (SELECT mum2.uom_class
6937: FROM mtl_units_of_measure mum2
7024: p_shipmentHeaderID) -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
7025: from wms_lpn_contents wlc,
7026: mtl_system_items_vl msn, /* Bug 5581528 */
7027: rcv_shipment_lines rsl,
7028: rcv_shipment_headers rsh, /* Added for Bug9257750 */
7029: mtl_cross_references mcr
7030: WHERE msn.organization_id = p_Organization_Id
7031: and wlc.parent_lpn_id = l_from_lpn_id
7032: and wlc.inventory_item_id = rsl.item_id
7100: DECODE (p_reqHeaderID,to_char(null),' ',
7101: p_shipmentHeaderID) -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
7102: from mtl_system_items_vl msn, /* Bug 5581528 */
7103: rcv_shipment_lines rsl,
7104: rcv_shipment_headers rsh /* Added for Bug9257750 */
7105: WHERE msn.organization_id = p_Organization_Id
7106: and msn.concatenated_segments like p_concatenated_segments||l_append
7107: and (msn.purchasing_enabled_flag = 'Y' OR msn.stock_enabled_flag = 'Y')
7108: and rsl.SHIPMENT_HEADER_ID = p_shipmentHeaderID
7171: p_shipmentHeaderID) -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
7172: from po_lines_trx_v pol -- CLM project, bug 9403291
7173: ,mtl_system_items_vl msi /* Bug 5581528 */
7174: ,rcv_shipment_lines rsl
7175: ,rcv_shipment_headers rsh /* Added for Bug9257750 */
7176: where msi.organization_id = p_Organization_Id
7177: and pol.vendor_product_num like p_concatenated_segments
7178: and pol.item_id = msi.inventory_item_id
7179: and pol.vendor_product_num IS NOT NULL
7267: p_shipmentHeaderID) -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
7268: from po_lines_trx_v pol -- CLM project, bug 9403291
7269: , mtl_units_of_measure mum
7270: ,rcv_shipment_lines rsl
7271: , rcv_shipment_headers rsh /* Added for Bug9257750 */
7272: -- Bug 2619063, 2614016
7273: -- Modified to select the base uom for the uom class defined on po.
7274: where mum.uom_class = (SELECT mum2.uom_class
7275: FROM mtl_units_of_measure mum2
7360: DECODE (p_reqHeaderID,to_char(null),' ',
7361: p_shipmentHeaderID) -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
7362: from mtl_system_items_vl msn, /* Bug 5581528 */
7363: rcv_shipment_lines rsl,
7364: rcv_shipment_headers rsh, /* Added for Bug9257750 */
7365: mtl_cross_references mcr
7366: WHERE msn.organization_id = p_Organization_Id
7367: and ( mcr.cross_reference_type = g_gtin_cross_ref_type
7368: AND mcr.cross_reference LIKE g_crossref
7605: SELECT rsl.Item_Id,rsh.shipment_num shipment_num, /* Added by Bug9257750 */
7606: rsh.shipment_header_id shipment_header_id
7607: FROM po_Req_Lines_trx_v prl, -- CLM project, bug 9403291
7608: rcv_Shipment_Lines rsl ,
7609: rcv_shipment_headers rsh,/* Added by Bug9257750 */
7610: po_req_Distributions_All prd
7611: WHERE prl.Requisition_Header_Id = p_reqHeadeRid
7612: AND rsh.shipment_header_id = rsl.shipment_header_id /* Added by Bug9257750 */
7613: AND l_From_lpn_Id IS NOT NULL
7693: rsh.shipment_header_id shipment_header_id
7694: FROM po_Req_Lines_trx_v prl, -- CLM project, bug 9403291
7695: rcv_Shipment_Lines rsl ,
7696: po_req_Distributions_All prd,
7697: rcv_shipment_headers rsh /* Added by Bug9257750 */
7698: WHERE prl.Requisition_Header_Id = p_reqHeadeRid
7699: AND rsh.shipment_header_id = rsl.shipment_header_id /* Added by Bug9257750 */
7700: AND l_From_lpn_Id IS NULL
7701: AND prl.Requisition_Line_Id = rsl.Requisition_Line_Id
7777: rsh.shipment_header_id shipment_header_id
7778: FROM po_req_lines_trx_v prl,
7779: rcv_Shipment_Lines rsl ,
7780: po_req_Distributions_All prd,
7781: rcv_shipment_headers rsh
7782: WHERE prl.Requisition_Header_Id = p_reqHeadeRid
7783: AND rsh.shipment_header_id = rsl.shipment_header_id
7784: AND l_From_lpn_Id IS NULL
7785: AND prl.Requisition_Line_Id = rsl.Requisition_Line_Id
9521: x_attribute13,
9522: x_attribute14,
9523: x_attribute15,
9524: x_attribute_category
9525: from rcv_shipment_headers rsh
9526: where rsh.shipment_num = l_shipment_num
9527: and rsh.ship_to_org_id = l_organization_id;
9528:
9529:
9545: l_attributes_tbl (14) := x_attribute14;
9546: l_attributes_tbl (15) := x_attribute15;
9547:
9548: l_dflex_r.application_id := 201;
9549: l_dflex_r.flexfield_name := 'RCV_SHIPMENT_HEADERS';
9550:
9551: print_debug('BEFORE SETTING THE ATTRIBUTES CONTEXT',4);
9552:
9553: l_dflex_r.application_id := 201;
9550:
9551: print_debug('BEFORE SETTING THE ATTRIBUTES CONTEXT',4);
9552:
9553: l_dflex_r.application_id := 201;
9554: l_dflex_r.flexfield_name := 'RCV_SHIPMENT_HEADERS';
9555:
9556: print_debug('BEFORE SETTING THE ATTRIBUTES CONTEXT',4);
9557:
9558: /* Get all contexts */
9661: fnd_flex_descval.set_context_value(l_context);
9662: End if;
9663:
9664: IF fnd_flex_descval.validate_desccols(appl_short_name => 'PO',
9665: desc_flex_name => 'RCV_SHIPMENT_HEADERS', values_or_ids => 'I'
9666: , validation_date => SYSDATE) THEN
9667: print_debug('Value set validation successful', 4);
9668: ELSE
9669: error_segment := fnd_flex_descval.error_segment;