DBA Data[Home] [Help]

APPS.INV_UI_RCV_LOVS dependencies on RCV_INTRANSIT_SV

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

642: sh.shipment_header_id,
643: sh.shipped_date,
644: sh.expected_receipt_date,
645: Decode(sh.receipt_source_code,'VENDOR',sh.vendor_id, sl.from_organization_id) from_organization_id,
646: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id,sl.from_organization_id),1,80) organization_name,
647: /* Bug 4253199 ** Receipt source code is fetched properly
648: Decode(sh.receipt_source_code,'VENDOR','Vendor','Organization'),
649: */
650: Decode(sh.receipt_source_code,'VENDOR','Vendor',sh.receipt_source_code),

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

675: sh.shipment_header_id,
676: sh.shipped_date,
677: sh.expected_receipt_date,
678: Decode(sh.receipt_source_code,'VENDOR',sh.vendor_id, sl.from_organization_id) from_organization_id,
679: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id,sl.from_organization_id),1,80) organization_name,
680: Decode(sh.receipt_source_code,'VENDOR','Vendor','Organization'),
681: sh.packing_slip,
682: sh.bill_of_lading,
683: sh.waybill_airbill_num,

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

900: sh.shipment_header_id,
901: sh.shipped_date,
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

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

920: sh.shipment_header_id,
921: sh.shipped_date,
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

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

2081: NULL FIELD4, --LSP
2082: NULL FIELD5 , --
2083: to_char(sh.expected_receipt_date) FIELD6,
2084: to_char(Decode(sh.receipt_source_code, 'VENDOR',sh.vendor_id, sl.from_organization_id)) FIELD7,
2085: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id, sl.from_organization_id),1,80) FIELD8,
2086: Decode(sh.receipt_source_code,'VENDOR','Vendor',sh.receipt_source_code) FIELD9, --bug fix 3939003
2087: sh.packing_slip FIELD10,
2088: sh.bill_of_lading FIELD11,
2089: sh.waybill_airbill_num FIELD12,

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

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

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

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

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

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

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

2260: NULL FIELD4, --LSP
2261: NULL FIELD5 , --
2262: to_char(sh.expected_receipt_date) FIELD6,
2263: to_char(Decode(sh.receipt_source_code, 'VENDOR',sh.vendor_id, sl.from_organization_id)) FIELD7,
2264: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id, sl.from_organization_id),1,80) FIELD8,
2265: Decode(sh.receipt_source_code,'VENDOR','Vendor','Organization') FIELD9,
2266: sh.packing_slip FIELD10,
2267: sh.bill_of_lading FIELD11,
2268: sh.waybill_airbill_num FIELD12,

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

2303: NULL FIELD4, --LSP
2304: NULL FIELD5 , --
2305: to_char(sh.expected_receipt_date) FIELD6,
2306: to_char(Decode(sh.receipt_source_code, 'VENDOR',sh.vendor_id, sl.from_organization_id)) FIELD7,
2307: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id, sl.from_organization_id),1,80) FIELD8,
2308: Decode(sh.receipt_source_code,'VENDOR','Vendor','Organization') FIELD9,
2309: sh.packing_slip FIELD10,
2310: sh.bill_of_lading FIELD11,
2311: sh.waybill_airbill_num FIELD12,

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

2347: NULL FIELD4, --LSP
2348: NULL FIELD5 , --
2349: to_char(sh.expected_receipt_date) FIELD6,
2350: to_char(Decode(sh.receipt_source_code, 'VENDOR',sh.vendor_id, sl.from_organization_id)) FIELD7,
2351: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id, sl.from_organization_id),1,80) FIELD8,
2352: Decode(sh.receipt_source_code,'VENDOR','Vendor','Organization') FIELD9,
2353: sh.packing_slip FIELD10,
2354: sh.bill_of_lading FIELD11,
2355: sh.waybill_airbill_num FIELD12,

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

2719: NULL FIELD4, --LSP
2720: NULL FIELD5 , --
2721: to_char(sh.expected_receipt_date) FIELD6,
2722: to_char(Decode(sh.receipt_source_code, 'VENDOR',sh.vendor_id, sl.from_organization_id)) FIELD7,
2723: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id, sl.from_organization_id),1,80) FIELD8,
2724: Decode(sh.receipt_source_code,'VENDOR','Vendor',sh.receipt_source_code) FIELD9, --bug fix 3939003
2725: sh.packing_slip FIELD10,
2726: sh.bill_of_lading FIELD11,
2727: sh.waybill_airbill_num FIELD12,

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

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

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

2818: NULL FIELD4, --LSP
2819: NULL FIELD5 , --
2820: to_char(sh.expected_receipt_date) FIELD6,
2821: to_char(Decode(sh.receipt_source_code, 'VENDOR',sh.vendor_id, sl.from_organization_id)) FIELD7,
2822: Substr( rcv_intransit_sv.rcv_get_org_name(sh.receipt_source_code,sh.vendor_id, sl.from_organization_id),1,80) FIELD8,
2823: Decode(sh.receipt_source_code,'VENDOR','Vendor','Organization') FIELD9,
2824: sh.packing_slip FIELD10,
2825: sh.bill_of_lading FIELD11,
2826: sh.waybill_airbill_num FIELD12,