DBA Data[Home] [Help]

APPS.INV_UI_RCV_LOVS dependencies on RCV_INTRANSIT_SV

Line 618: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id,sl.from_organization_id),1,80) organization_name,

614: sh.shipment_header_id,
615: sh.shipped_date,
616: sh.expected_receipt_date,
617: Decode(sh.receipt_source_code,'VENDOR',sh.vendor_id, sl.from_organization_id) from_organization_id,
618: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id,sl.from_organization_id),1,80) organization_name,
619: /* Bug 4253199 ** Receipt source code is fetched properly
620: Decode(sh.receipt_source_code,'VENDOR','Vendor','Organization'),
621: */
622: Decode(sh.receipt_source_code,'VENDOR','Vendor',sh.receipt_source_code),

Line 651: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id,sl.from_organization_id),1,80) organization_name,

647: sh.shipment_header_id,
648: sh.shipped_date,
649: sh.expected_receipt_date,
650: Decode(sh.receipt_source_code,'VENDOR',sh.vendor_id, sl.from_organization_id) from_organization_id,
651: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id,sl.from_organization_id),1,80) organization_name,
652: Decode(sh.receipt_source_code,'VENDOR','Vendor','Organization'),
653: sh.packing_slip,
654: sh.bill_of_lading,
655: sh.waybill_airbill_num,

Line 876: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id,sl.from_organization_id),1,80) organization_name,

872: sh.shipment_header_id,
873: sh.shipped_date,
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

Line 896: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id,sl.from_organization_id),1,80) organization_name,

892: sh.shipment_header_id,
893: sh.shipped_date,
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

Line 2042: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id, sl.from_organization_id),1,80) FIELD7,

2038: to_char(sh.shipped_date) FIELD3,
2039: NULL FIELD4 , --
2040: to_char(sh.expected_receipt_date) FIELD5,
2041: to_char(Decode(sh.receipt_source_code, 'VENDOR',sh.vendor_id, sl.from_organization_id)) FIELD6,
2042: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id, sl.from_organization_id),1,80) FIELD7,
2043: Decode(sh.receipt_source_code,'VENDOR','Vendor',sh.receipt_source_code) FIELD8, --bug fix 3939003
2044: sh.packing_slip FIELD9,
2045: sh.bill_of_lading FIELD10,
2046: sh.waybill_airbill_num FIELD11,

Line 2089: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id, sl.from_organization_id),1,80) FIELD7,

2085: to_char(sh.shipped_date) FIELD3,
2086: NULL FIELD4 , --
2087: to_char(sh.expected_receipt_date) FIELD5,
2088: to_char(Decode(sh.receipt_source_code, 'VENDOR',sh.vendor_id, sl.from_organization_id)) FIELD6,
2089: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id, sl.from_organization_id),1,80) FIELD7,
2090: Decode(sh.receipt_source_code,'VENDOR','Vendor','Organization') FIELD8,
2091: sh.packing_slip FIELD9,
2092: sh.bill_of_lading FIELD10,
2093: sh.waybill_airbill_num FIELD11,

Line 2131: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id, sl.from_organization_id),1,80) FIELD7,

2127: to_char(sh.shipped_date) FIELD3,
2128: NULL FIELD4 , --
2129: to_char(sh.expected_receipt_date) FIELD5,
2130: to_char(Decode(sh.receipt_source_code, 'VENDOR',sh.vendor_id, sl.from_organization_id)) FIELD6,
2131: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id, sl.from_organization_id),1,80) FIELD7,
2132: Decode(sh.receipt_source_code,'VENDOR','Vendor','Organization') FIELD8,
2133: sh.packing_slip FIELD9,
2134: sh.bill_of_lading FIELD10,
2135: sh.waybill_airbill_num FIELD11,

Line 2174: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id, sl.from_organization_id),1,80) FIELD7,

2170: to_char(sh.shipped_date) FIELD3,
2171: NULL FIELD4 , --
2172: to_char(sh.expected_receipt_date) FIELD5,
2173: to_char(Decode(sh.receipt_source_code, 'VENDOR',sh.vendor_id, sl.from_organization_id)) FIELD6,
2174: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id, sl.from_organization_id),1,80) FIELD7,
2175: Decode(sh.receipt_source_code,'VENDOR','Vendor','Organization') FIELD8,
2176: sh.packing_slip FIELD9,
2177: sh.bill_of_lading FIELD10,
2178: sh.waybill_airbill_num FIELD11,

Line 2217: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id, sl.from_organization_id),1,80) FIELD7,

2213: to_char(sh.shipped_date) FIELD3,
2214: NULL FIELD4 , --
2215: to_char(sh.expected_receipt_date) FIELD5,
2216: to_char(Decode(sh.receipt_source_code, 'VENDOR',sh.vendor_id, sl.from_organization_id)) FIELD6,
2217: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id, sl.from_organization_id),1,80) FIELD7,
2218: Decode(sh.receipt_source_code,'VENDOR','Vendor','Organization') FIELD8,
2219: sh.packing_slip FIELD9,
2220: sh.bill_of_lading FIELD10,
2221: sh.waybill_airbill_num FIELD11,

Line 2259: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id, sl.from_organization_id),1,80) FIELD7,

2255: to_char(sh.shipped_date) FIELD3,
2256: NULL FIELD4 , --
2257: to_char(sh.expected_receipt_date) FIELD5,
2258: to_char(Decode(sh.receipt_source_code, 'VENDOR',sh.vendor_id, sl.from_organization_id)) FIELD6,
2259: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id, sl.from_organization_id),1,80) FIELD7,
2260: Decode(sh.receipt_source_code,'VENDOR','Vendor','Organization') FIELD8,
2261: sh.packing_slip FIELD9,
2262: sh.bill_of_lading FIELD10,
2263: sh.waybill_airbill_num FIELD11,

Line 2302: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id, sl.from_organization_id),1,80) FIELD7,

2298: to_char(sh.shipped_date) FIELD3,
2299: NULL FIELD4 , --
2300: to_char(sh.expected_receipt_date) FIELD5,
2301: to_char(Decode(sh.receipt_source_code, 'VENDOR',sh.vendor_id, sl.from_organization_id)) FIELD6,
2302: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id, sl.from_organization_id),1,80) FIELD7,
2303: Decode(sh.receipt_source_code,'VENDOR','Vendor','Organization') FIELD8,
2304: sh.packing_slip FIELD9,
2305: sh.bill_of_lading FIELD10,
2306: sh.waybill_airbill_num FIELD11,

Line 2668: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id, sl.from_organization_id),1,80) FIELD7,

2664: to_char(sh.shipped_date) FIELD3,
2665: NULL FIELD4 , --
2666: to_char(sh.expected_receipt_date) FIELD5,
2667: to_char(Decode(sh.receipt_source_code, 'VENDOR',sh.vendor_id, sl.from_organization_id)) FIELD6,
2668: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id, sl.from_organization_id),1,80) FIELD7,
2669: Decode(sh.receipt_source_code,'VENDOR','Vendor',sh.receipt_source_code) FIELD8, --bug fix 3939003
2670: sh.packing_slip FIELD9,
2671: sh.bill_of_lading FIELD10,
2672: sh.waybill_airbill_num FIELD11,

Line 2712: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id, sl.from_organization_id),1,80) FIELD7,

2708: to_char(sh.shipped_date) FIELD3,
2709: NULL FIELD4 , --
2710: to_char(sh.expected_receipt_date) FIELD5,
2711: to_char(Decode(sh.receipt_source_code, 'VENDOR',sh.vendor_id, sl.from_organization_id)) FIELD6,
2712: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id, sl.from_organization_id),1,80) FIELD7,
2713: Decode(sh.receipt_source_code,'VENDOR','Vendor','Organization') FIELD8,
2714: sh.packing_slip FIELD9,
2715: sh.bill_of_lading FIELD10,
2716: sh.waybill_airbill_num FIELD11,

Line 2765: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id, sl.from_organization_id),1,80) FIELD7,

2761: to_char(sh.shipped_date) FIELD3,
2762: NULL FIELD4 , --
2763: to_char(sh.expected_receipt_date) FIELD5,
2764: to_char(Decode(sh.receipt_source_code, 'VENDOR',sh.vendor_id, sl.from_organization_id)) FIELD6,
2765: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id, sl.from_organization_id),1,80) FIELD7,
2766: Decode(sh.receipt_source_code,'VENDOR','Vendor','Organization') FIELD8,
2767: sh.packing_slip FIELD9,
2768: sh.bill_of_lading FIELD10,
2769: sh.waybill_airbill_num FIELD11,