[Home] [Help]
580: rsh.bill_of_lading,
581: rsh.waybill_airbill_num,
582: rsh.freight_carrier_code
583: FROM
584: rcv_shipment_headers rsh,
585: rcv_shipment_lines rsl,
586: rcv_supply ms,
587: rcv_transactions rt,
588: org_organization_definitions ood
623: sh.packing_slip,
624: sh.bill_of_lading,
625: sh.waybill_airbill_num,
626: sh.freight_carrier_code
627: FROM rcv_shipment_headers sh,
628: rcv_shipment_lines sl
629: WHERE sh.shipment_num IS NOT NULL
630: AND sh.shipment_header_id = sl.shipment_header_id
631: AND sl.to_organization_id = p_organization_id
653: sh.packing_slip,
654: sh.bill_of_lading,
655: sh.waybill_airbill_num,
656: sh.freight_carrier_code
657: FROM rcv_shipment_headers sh,
658: rcv_shipment_lines sl
659: WHERE sh.shipment_num IS NOT NULL
660: AND sh.shipment_header_id = sl.shipment_header_id
661: AND sl.to_organization_id = p_organization_id
688: rsh.freight_carrier_code
689: FROM RCV_SUPPLY RSUP,
690: RCV_SHIPMENT_LINES RSL,
691: RCV_TRANSACTIONS RT,
692: RCV_SHIPMENT_HEADERS RSH,
693: PO_LOOKUP_CODES PLC,
694: PO_LINE_LOCATIONS_ALL PLL,
695: HR_ALL_ORGANIZATION_UNITS_TL OOD
696: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
835: AND prh.segment1 LIKE (p_requisition_num)
836: AND exists
837: (SELECT 1
838: FROM rcv_shipment_lines rsl,
839: rcv_shipment_headers rsh,
840: rcv_transactions_v rtv
841: WHERE rsl.requisition_line_id = prl.requisition_line_id
842: AND rsh.shipment_header_id = rsl.shipment_header_id
843: AND rtv.shipment_header_id = rsh.shipment_header_id
874: sh.expected_receipt_date,
875: Decode(sh.receipt_source_code,'VENDOR',sh.vendor_id, sl.from_organization_id) from_organization_id,
876: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id,sl.from_organization_id),1,80) organization_name,
877: Decode(sh.receipt_source_code,'VENDOR','Vendor','Organization')
878: FROM rcv_shipment_headers sh,
879: rcv_shipment_lines sl
880: WHERE sh.packing_slip IS NOT NULL
881: AND sh.shipment_header_id = sl.shipment_header_id
882: AND sl.to_organization_id = p_organization_id
894: sh.expected_receipt_date,
895: Decode(sh.receipt_source_code,'VENDOR',sh.vendor_id, sl.from_organization_id) from_organization_id,
896: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id,sl.from_organization_id),1,80) organization_name,
897: Decode(sh.receipt_source_code,'VENDOR','Vendor','Organization')
898: FROM rcv_shipment_headers sh,
899: rcv_shipment_lines sl
900: WHERE sh.packing_slip IS NOT NULL
901: AND sh.shipment_header_id = sl.shipment_header_id
902: AND sl.to_organization_id = p_organization_id
923: , rt.po_header_id
924: , rt.oe_order_header_id
925: FROM rcv_supply ms
926: , rcv_transactions rt
927: , rcv_shipment_headers rsh
928: , rcv_shipment_lines rsl
929: , mtl_parameters mp
930: WHERE rsh.shipment_header_id = ms.shipment_header_id
931: AND rsh.shipment_header_id = rt.shipment_header_id
1078: null ,
1079: null
1080: FROM RCV_SUPPLY RSUP,
1081: RCV_TRANSACTIONS RT,
1082: RCV_SHIPMENT_HEADERS RSH,
1083: RCV_SHIPMENT_LINES RSL,
1084: PO_LOOKUP_CODES PLC,
1085: PO_LINE_LOCATIONS_ALL PLL,
1086: mtl_parameters mp --BUG 5166887
2047: sh.freight_carrier_code FIELD12,
2048: lookup_code FIELD13,
2049: NULL FIELD14 --
2050: FROM fnd_lookup_values_vl flv,
2051: rcv_shipment_headers sh,
2052: rcv_shipment_lines sl
2053: WHERE flv.lookup_code = 'INTSHIP'
2054: AND flv.lookup_type = 'DOC_TYPE'
2055: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2094: sh.freight_carrier_code FIELD12,
2095: lookup_code FIELD13,
2096: NULL FIELD14 --
2097: FROM fnd_lookup_values_vl flv,
2098: rcv_shipment_headers sh,
2099: rcv_shipment_lines sl
2100: WHERE flv.lookup_code = 'ASN'
2101: AND flv.lookup_type = 'DOC_TYPE'
2102: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2136: sh.freight_carrier_code FIELD12,
2137: lookup_code FIELD13,
2138: NULL FIELD14 --
2139: FROM fnd_lookup_values_vl flv,
2140: rcv_shipment_headers sh,
2141: rcv_shipment_lines sl
2142: WHERE flv.lookup_code = 'ASN'
2143: AND flv.lookup_type = 'DOC_TYPE'
2144: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2179: sh.freight_carrier_code FIELD12,
2180: lookup_code FIELD13 ,
2181: NULL FIELD14 --
2182: FROM fnd_lookup_values_vl flv,
2183: rcv_shipment_headers sh,
2184: rcv_shipment_lines sl
2185: WHERE flv.lookup_code = 'ASN'
2186: AND flv.lookup_type = 'DOC_TYPE'
2187: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2222: sh.freight_carrier_code FIELD12,
2223: lookup_code FIELD13,
2224: NULL FIELD14 --
2225: FROM fnd_lookup_values_vl flv,
2226: rcv_shipment_headers sh,
2227: rcv_shipment_lines sl
2228: WHERE flv.lookup_code = 'LCM'
2229: AND flv.lookup_type = 'DOC_TYPE'
2230: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2264: sh.freight_carrier_code FIELD12,
2265: lookup_code FIELD13,
2266: NULL FIELD14 --
2267: FROM fnd_lookup_values_vl flv,
2268: rcv_shipment_headers sh,
2269: rcv_shipment_lines sl
2270: WHERE flv.lookup_code = 'LCM'
2271: AND flv.lookup_type = 'DOC_TYPE'
2272: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2307: sh.freight_carrier_code FIELD12,
2308: lookup_code FIELD13 ,
2309: NULL FIELD14 --
2310: FROM fnd_lookup_values_vl flv,
2311: rcv_shipment_headers sh,
2312: rcv_shipment_lines sl
2313: WHERE flv.lookup_code = 'LCM'
2314: AND flv.lookup_type = 'DOC_TYPE'
2315: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2673: sh.freight_carrier_code FIELD12,
2674: lookup_code FIELD13,
2675: NULL FIELD14 --
2676: FROM fnd_lookup_values_vl flv,
2677: rcv_shipment_headers sh,
2678: rcv_shipment_lines sl
2679: WHERE flv.lookup_code = 'INTSHIP'
2680: AND flv.lookup_type = 'DOC_TYPE'
2681: AND nvl(flv.start_date_active, SYSDATE )<= SYSDATE
2717: sh.freight_carrier_code FIELD12,
2718: lookup_code FIELD13,
2719: NULL FIELD14 --
2720: FROM fnd_lookup_values_vl flv,
2721: rcv_shipment_headers sh,
2722: rcv_shipment_lines sl
2723: WHERE flv.lookup_code = 'ASN'
2724: AND flv.lookup_type = 'DOC_TYPE'
2725: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2770: sh.freight_carrier_code FIELD12,
2771: lookup_code FIELD13,
2772: NULL FIELD14 --
2773: FROM fnd_lookup_values_vl flv,
2774: rcv_shipment_headers sh,
2775: rcv_shipment_lines sl
2776: WHERE flv.lookup_code = 'LCM'
2777: AND flv.lookup_type = 'DOC_TYPE'
2778: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
8445: x_attribute13,
8446: x_attribute14,
8447: x_attribute15,
8448: x_attribute_category
8449: from rcv_shipment_headers rsh
8450: where rsh.shipment_num = l_shipment_num
8451: and rsh.ship_to_org_id = l_organization_id;
8452:
8453:
8469: l_attributes_tbl (14) := x_attribute14;
8470: l_attributes_tbl (15) := x_attribute15;
8471:
8472: l_dflex_r.application_id := 201;
8473: l_dflex_r.flexfield_name := 'RCV_SHIPMENT_HEADERS';
8474:
8475: print_debug('BEFORE SETTING THE ATTRIBUTES CONTEXT',4);
8476:
8477: l_dflex_r.application_id := 201;
8474:
8475: print_debug('BEFORE SETTING THE ATTRIBUTES CONTEXT',4);
8476:
8477: l_dflex_r.application_id := 201;
8478: l_dflex_r.flexfield_name := 'RCV_SHIPMENT_HEADERS';
8479:
8480: print_debug('BEFORE SETTING THE ATTRIBUTES CONTEXT',4);
8481:
8482: /* Get all contexts */
8585: fnd_flex_descval.set_context_value(l_context);
8586: End if;
8587:
8588: IF fnd_flex_descval.validate_desccols(appl_short_name => 'PO',
8589: desc_flex_name => 'RCV_SHIPMENT_HEADERS', values_or_ids => 'I'
8590: , validation_date => SYSDATE) THEN
8591: print_debug('Value set validation successful', 4);
8592: ELSE
8593: error_segment := fnd_flex_descval.error_segment;