eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCV_ROI_TRANSACTION dependencies on PO_LINES

Line 651: po_lines pl,

647: pll.value_basis , --Complex Work
648: pl.purchase_basis,
649: pll.matching_basis --Complex Work
650: FROM po_line_locations pll,
651: po_lines pl,
652: po_headers ph
653: WHERE ph.po_header_id = pl.po_header_id
654: AND pl.po_line_id = pll.po_line_id
655: AND ph.po_header_id = v_header_id

Line 1954: FROM po_lines_trx_v

1950: BEGIN
1951:
1952: SELECT po_line_id
1953: INTO x_cascaded_table(n).po_line_id
1954: FROM po_lines_trx_v
1955: WHERE po_header_id = x_cascaded_table(n).po_header_id
1956: AND po_line_id = x_cascaded_table(n).po_line_id;
1957:
1958: EXCEPTION

Line 1980: FROM po_lines

1976: NVL(matching_basis, 'QUANTITY')
1977: INTO x_cascaded_table(n).value_basis,
1978: x_cascaded_table(n).purchase_basis,
1979: x_cascaded_table(n).matching_basis
1980: FROM po_lines
1981: WHERE po_line_id = x_cascaded_table(n).po_line_id;
1982: ELSE
1983: -- we require line info for receiving against services lines
1984: x_cascaded_table(n).matching_basis := 'QUANTITY';

Line 3212: po_lines pl,

3208: NVL(pll.enforce_ship_to_location_code, 'NONE') enforce_ship_to_location_code,
3209: TO_NUMBER(NULL) shipment_line_id, --shipment_line_id
3210: pl.item_id
3211: FROM po_line_locations pll,
3212: po_lines pl,
3213: po_headers ph
3214: WHERE ph.po_header_id = header_id
3215: AND pll.po_header_id = header_id
3216: AND pl.line_num = NVL(v_po_line_num, pl.line_num)

Line 3245: po_lines pl,

3241: v_vendor_product_num VARCHAR2
3242: ) IS
3243: SELECT COUNT(*)
3244: FROM po_line_locations pll,
3245: po_lines pl,
3246: po_headers ph
3247: WHERE ph.po_header_id = header_id
3248: AND pll.po_header_id = header_id
3249: AND pl.line_num = NVL(v_po_line_num, pl.line_num)

Line 3269: ***** followed by PO_LINES_ALL which is followed by PO_LINE_LOCATIONS_ALL

3265: /***** Bug # 1553154
3266: ***** There was a performance issue since the cursor COUNT_DISTRIBUTIONS
3267: ***** was driving through PO_LINE_LOCATIONS_ALL. Modified the Select
3268: ***** statement so that it will drive through PO_HEADERS_ALL
3269: ***** followed by PO_LINES_ALL which is followed by PO_LINE_LOCATIONS_ALL
3270: ***** so that there is an improvement in performance.
3271: *****/
3272: CURSOR distributions(
3273: header_id NUMBER,

Line 3327: po_lines pl,

3323: TO_NUMBER(NULL) shipment_line_id, -- shipment_line_id
3324: pl.item_id
3325: FROM po_distributions pod,
3326: po_line_locations pll,
3327: po_lines pl,
3328: po_headers ph
3329: WHERE ph.po_header_id = header_id
3330: AND pl.po_header_id = ph.po_header_id
3331: AND pll.po_line_id = pl.po_line_id

Line 3354: ***** PO_HEADERS_ALL followed by PO_LINES_ALL which is followed by

3350: /***** Bug # 1553154
3351: ***** There was a performance issue since the cursor DISTRIBUTIONS
3352: ***** was driving through PO_HEADERS_ALL followed by PO_DISTRIBUTIONS_ALL
3353: ***** Modified the Select statement so that it will drive through
3354: ***** PO_HEADERS_ALL followed by PO_LINES_ALL which is followed by
3355: ***** PO_LINE_LOCATIONS_ALL which in turn is followed by
3356: ***** PO_DISTRIBUTIONS_ALL so that there is an improvement in
3357: ***** Performance
3358: *****/

Line 3373: po_lines pl,

3369: ) IS
3370: SELECT COUNT(*)
3371: FROM po_distributions pod,
3372: po_line_locations pll,
3373: po_lines pl,
3374: po_headers ph
3375: WHERE ph.po_header_id = header_id
3376: AND pl.po_header_id = ph.po_header_id
3377: AND pll.po_line_id = pl.po_line_id

Line 3563: FROM po_lines

3559: AND temp_cascaded_table(current_n).po_line_id IS NOT NULL THEN --{
3560: BEGIN
3561: SELECT line_num
3562: INTO temp_cascaded_table(current_n).document_line_num
3563: FROM po_lines
3564: WHERE po_line_id = temp_cascaded_table(current_n).po_line_id;
3565: EXCEPTION
3566: WHEN OTHERS THEN
3567: IF (g_asn_debug = 'Y') THEN

Line 4245: po_lines pl,

4241: IF (x_is_asn = FALSE) THEN --{
4242: SELECT COUNT(*)
4243: INTO x_temp_count
4244: FROM po_line_locations pll,
4245: po_lines pl,
4246: po_headers ph
4247: WHERE ph.po_header_id = temp_cascaded_table(current_n).po_header_id
4248: AND pll.po_header_id = ph.po_header_id
4249: AND pl.line_num = NVL(temp_cascaded_table(current_n).document_line_num, pl.line_num)

Line 4287: po_lines pl,

4283: x_ship_to_organization_id,
4284: x_ship_to_location_id,
4285: x_vendor_product_num
4286: FROM po_line_locations pll,
4287: po_lines pl,
4288: po_headers ph
4289: WHERE ph.po_header_id = temp_cascaded_table(current_n).po_header_id
4290: AND pll.po_header_id = ph.po_header_id
4291: AND pl.line_num = NVL(temp_cascaded_table(current_n).document_line_num, pl.line_num)

Line 4320: po_lines pl,

4316: SELECT COUNT(*)
4317: INTO x_temp_count
4318: FROM po_distributions pod,
4319: po_line_locations pll,
4320: po_lines pl,
4321: po_headers ph
4322: WHERE ph.po_header_id = temp_cascaded_table(current_n).po_header_id
4323: AND pll.po_header_id = ph.po_header_id
4324: AND pll.line_location_id = pod.line_location_id

Line 4365: po_lines pl,

4361: x_ship_to_location_id,
4362: x_vendor_product_num
4363: FROM po_distributions pod,
4364: po_line_locations pll,
4365: po_lines pl,
4366: po_headers ph
4367: WHERE ph.po_header_id = temp_cascaded_table(current_n).po_header_id
4368: AND pll.po_header_id = ph.po_header_id
4369: AND pll.line_location_id = pod.line_location_id

Line 4419: po_lines pl,

4415: l_receipt_source_code,
4416: l_shipment_line_status_code,
4417: l_asn_line_flag
4418: FROM po_line_locations pll,
4419: po_lines pl,
4420: po_headers ph,
4421: rcv_shipment_headers rsh,
4422: rcv_shipment_lines rsl
4423: WHERE rsh.shipment_header_id = temp_cascaded_table(current_n).shipment_header_id

Line 5922: po_lines pl,

5918: pll.ship_to_location_id,
5919: NVL(pll.enforce_ship_to_location_code, 'NONE') enforce_ship_to_location_code,
5920: pl.item_id
5921: FROM po_line_locations pll,
5922: po_lines pl,
5923: po_headers ph
5924: WHERE pl.po_line_id = v_po_line_id
5925: AND pll.po_line_id = v_po_line_id
5926: AND ph.po_header_id = pl.po_header_id

Line 5945: po_lines pl,

5941: v_po_release_id NUMBER
5942: ) IS
5943: SELECT COUNT(*)
5944: FROM po_line_locations pll,
5945: po_lines pl,
5946: po_headers ph
5947: WHERE pl.po_line_id = v_po_line_id
5948: AND pll.po_line_id = v_po_line_id
5949: AND ph.po_header_id = pl.po_header_id

Line 6003: po_lines pl,

5999: NVL(pll.enforce_ship_to_location_code, 'NONE') enforce_ship_to_location_code,
6000: pl.item_id
6001: FROM po_distributions pod,
6002: po_line_locations pll,
6003: po_lines pl,
6004: po_headers ph
6005: WHERE pl.po_line_id = v_po_line_id
6006: AND pll.po_line_id = v_po_line_id
6007: AND ph.po_header_id = pl.po_header_id

Line 6030: po_lines pl,

6026: ) IS
6027: SELECT COUNT(*)
6028: FROM po_distributions pod,
6029: po_line_locations pll,
6030: po_lines pl,
6031: po_headers ph
6032: WHERE pl.po_line_id = v_po_line_id
6033: AND pll.po_line_id = v_po_line_id
6034: AND ph.po_header_id = pl.po_header_id

Line 6145: po_lines pol

6141: */
6142: SELECT COUNT(*)
6143: INTO l_time_count
6144: FROM hxc_time_building_blocks bb,
6145: po_lines pol
6146: WHERE bb.time_building_block_id = x_cascaded_table(n).timecard_id
6147: AND bb.object_version_number = x_cascaded_table(n).timecard_ovn
6148: AND bb.SCOPE = 'TIMECARD'
6149: AND bb.resource_type = 'PERSON'

Line 6235: FROM po_lines

6231: AND temp_cascaded_table(current_n).po_line_id IS NOT NULL THEN --{
6232: BEGIN
6233: SELECT line_num
6234: INTO temp_cascaded_table(current_n).document_line_num
6235: FROM po_lines
6236: WHERE po_line_id = temp_cascaded_table(current_n).po_line_id;
6237: EXCEPTION
6238: WHEN OTHERS THEN
6239: IF (g_asn_debug = 'Y') THEN

Line 6623: po_lines pl

6619: INTO x_temp_count
6620: FROM DUAL
6621: WHERE EXISTS(SELECT 1
6622: FROM po_line_locations pll,
6623: po_lines pl
6624: WHERE pl.po_line_id = temp_cascaded_table(current_n).po_line_id
6625: AND NVL(pll.po_release_id, 0) = NVL(temp_cascaded_table(current_n).po_release_id, NVL(pll.po_release_id, 0))
6626: AND pll.line_location_id = NVL(temp_cascaded_table(current_n).po_line_location_id, pll.line_location_id)
6627: AND pll.po_line_id = pl.po_line_id);

Line 6646: po_lines pl,

6642: x_cancel_flag,
6643: x_closed_code,
6644: x_shipment_type
6645: FROM po_line_locations pll,
6646: po_lines pl,
6647: po_headers ph
6648: WHERE ph.po_header_id = temp_cascaded_table(current_n).po_header_id
6649: AND pll.po_header_id = ph.po_header_id
6650: AND pl.line_num = NVL(temp_cascaded_table(current_n).document_line_num, pl.line_num)

Line 6662: po_lines pl,

6658: SELECT COUNT(*)
6659: INTO x_temp_count
6660: FROM po_distributions pod,
6661: po_line_locations pll,
6662: po_lines pl,
6663: po_headers ph
6664: WHERE ph.po_header_id = temp_cascaded_table(current_n).po_header_id
6665: AND pll.po_header_id = ph.po_header_id
6666: AND pll.line_location_id = pod.line_location_id

Line 6691: po_lines pl,

6687: x_closed_code,
6688: x_shipment_type
6689: FROM po_distributions pod,
6690: po_line_locations pll,
6691: po_lines pl,
6692: po_headers ph
6693: WHERE ph.po_header_id = temp_cascaded_table(current_n).po_header_id
6694: AND pll.po_header_id = ph.po_header_id
6695: AND pll.line_location_id = pod.line_location_id

Line 7603: l_pol_item_id po_lines_all.item_id%type; --Bug: 5598511

7599: item_revision_record rcv_shipment_line_sv.item_id_record_type;
7600: sub_item_id_record rcv_shipment_line_sv.sub_item_id_record_type;
7601: item_id_record rcv_shipment_line_sv.item_id_record_type;
7602: l_asn_sub_item_txn varchar2(1); --Bug: 5598511
7603: l_pol_item_id po_lines_all.item_id%type; --Bug: 5598511
7604: BEGIN
7605: -- validate item id
7606: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN
7607: RETURN;

Line 8493: l_job_id po_lines.job_id%TYPE;

8489: n IN BINARY_INTEGER,
8490: x_header_record IN rcv_roi_preprocessor.header_rec_type
8491: ) IS
8492: ref_integrity_record rcv_shipment_line_sv.ref_integrity_record_type;
8493: l_job_id po_lines.job_id%TYPE;
8494: l_item_description po_lines.item_description%TYPE;
8495: l_category_id po_lines.category_id%TYPE;
8496: x_error_status VARCHAR2(1);
8497: BEGIN

Line 8494: l_item_description po_lines.item_description%TYPE;

8490: x_header_record IN rcv_roi_preprocessor.header_rec_type
8491: ) IS
8492: ref_integrity_record rcv_shipment_line_sv.ref_integrity_record_type;
8493: l_job_id po_lines.job_id%TYPE;
8494: l_item_description po_lines.item_description%TYPE;
8495: l_category_id po_lines.category_id%TYPE;
8496: x_error_status VARCHAR2(1);
8497: BEGIN
8498: x_error_status := rcv_error_pkg.g_ret_sts_error;

Line 8495: l_category_id po_lines.category_id%TYPE;

8491: ) IS
8492: ref_integrity_record rcv_shipment_line_sv.ref_integrity_record_type;
8493: l_job_id po_lines.job_id%TYPE;
8494: l_item_description po_lines.item_description%TYPE;
8495: l_category_id po_lines.category_id%TYPE;
8496: x_error_status VARCHAR2(1);
8497: BEGIN
8498: x_error_status := rcv_error_pkg.g_ret_sts_error;
8499:

Line 8577: FROM po_lines

8573: END IF;
8574:
8575: SELECT NVL(MAX(job_id), 0)
8576: INTO l_job_id
8577: FROM po_lines
8578: WHERE po_line_id = x_cascaded_table(n).po_line_id
8579: AND job_id = x_cascaded_table(n).job_id;
8580:
8581: IF (g_asn_debug = 'Y') THEN

Line 8595: * null then in po_lines. For other POs

8591: IF (x_cascaded_table(n).item_description IS NOT NULL) THEN
8592:
8593: /* Complex work.
8594: * For work confirmations check in shipment level. If
8595: * null then in po_lines. For other POs
8596: * check in po_lines.
8597: */
8598:
8599: If (nvl(x_header_record.header_record.asn_type,'STD') = 'WC') then --{

Line 8596: * check in po_lines.

8592:
8593: /* Complex work.
8594: * For work confirmations check in shipment level. If
8595: * null then in po_lines. For other POs
8596: * check in po_lines.
8597: */
8598:
8599: If (nvl(x_header_record.header_record.asn_type,'STD') = 'WC') then --{
8600:

Line 8614: FROM po_lines

8610: WHEN NO_DATA_FOUND THEN
8611: BEGIN
8612: SELECT (item_description)
8613: INTO l_item_description
8614: FROM po_lines
8615: WHERE po_line_id = x_cascaded_table(n).po_line_id
8616: AND item_description =
8617: x_cascaded_table(n).item_description;
8618: EXCEPTION

Line 8629: FROM po_lines

8625: else --}{
8626: BEGIN
8627: SELECT (item_description)
8628: INTO l_item_description
8629: FROM po_lines
8630: WHERE po_line_id = x_cascaded_table(n).po_line_id
8631: AND item_description = x_cascaded_table(n).item_description;
8632: EXCEPTION
8633: WHEN NO_DATA_FOUND THEN

Line 8652: FROM po_lines

8648:
8649: IF (x_cascaded_table(n).category_id IS NOT NULL) THEN
8650: SELECT NVL(MAX(category_id), 0)
8651: INTO l_category_id
8652: FROM po_lines
8653: WHERE po_line_id = x_cascaded_table(n).po_line_id
8654: AND category_id = x_cascaded_table(n).category_id;
8655:
8656: IF (g_asn_debug = 'Y') THEN

Line 8937: x_po_line_id po_lines.po_line_id%TYPE;

8933: x_ref_integrity_rec IN OUT NOCOPY rcv_shipment_line_sv.ref_integrity_record_type,
8934: x_header_record IN rcv_roi_preprocessor.header_rec_type
8935: ) IS
8936: x_po_vendor_id po_headers.vendor_id%TYPE := NULL;
8937: x_po_line_id po_lines.po_line_id%TYPE;
8938: x_po_vendor_site_id po_headers.vendor_site_id%TYPE := NULL;
8939: x_progress VARCHAR2(3);
8940: x_error_status VARCHAR2(1);
8941: BEGIN

Line 8947: FROM po_lines

8943:
8944: IF (x_ref_integrity_rec.vendor_item_num IS NOT NULL) THEN
8945: SELECT NVL(MAX(po_line_id), 0)
8946: INTO x_po_line_id
8947: FROM po_lines
8948: WHERE po_line_id = x_ref_integrity_rec.po_line_id
8949: AND vendor_product_num = x_ref_integrity_rec.vendor_item_num;
8950:
8951: IF (x_po_line_id = 0) THEN

Line 10447: po_lines pol

10443: FROM rcv_supply rsup,
10444: rcv_transactions rt,
10445: rcv_shipment_lines rsl,
10446: po_headers poh,
10447: po_lines pol
10448: WHERE rt.transaction_id = v_parent_trx_id
10449: AND rsup.to_organization_id = NVL(v_to_organization_id, rsup.to_organization_id)
10450: AND rsup.supply_type_code = 'RECEIVING'
10451: AND poh.po_header_id = rsup.po_header_id

Line 10554: po_lines pol,

10550: FROM rcv_supply rsup,
10551: rcv_transactions rt,
10552: rcv_shipment_lines rsl,
10553: po_headers poh,
10554: po_lines pol,
10555: po_distributions pod
10556: WHERE rt.transaction_id = v_parent_trx_id
10557: AND rsup.to_organization_id = NVL(v_to_organization_id, rsup.to_organization_id)
10558: AND rsup.supply_type_code = 'RECEIVING'

Line 10669: po_lines pol,

10665: FROM rcv_supply rsup,
10666: rcv_transactions rt,
10667: rcv_shipment_lines rsl,
10668: po_headers poh,
10669: po_lines pol,
10670: po_distributions pod
10671: WHERE rt.transaction_id = v_parent_trx_id
10672: AND rsup.to_organization_id = NVL(v_to_organization_id, rsup.to_organization_id)
10673: AND rsup.supply_type_code = 'RECEIVING'

Line 10777: po_lines pol,

10773: FROM rcv_supply rsup,
10774: rcv_transactions rt,
10775: rcv_shipment_lines rsl,
10776: po_headers poh,
10777: po_lines pol,
10778: po_distributions pod
10779: WHERE rt.transaction_id = v_parent_trx_id
10780: AND rsup.to_organization_id = NVL(v_to_organization_id, rsup.to_organization_id)
10781: AND rsup.supply_type_code = 'RECEIVING'

Line 10833: l_value_basis po_lines.order_type_lookup_code%TYPE;

10829: temp_index NUMBER;
10830: l_supply_code rcv_supply.supply_type_code%TYPE;
10831: l_transaction_type rcv_transactions.transaction_type%TYPE;
10832: /* FPJ SERVICES */
10833: l_value_basis po_lines.order_type_lookup_code%TYPE;
10834: l_purchase_basis po_lines.purchase_basis%TYPE;
10835: l_matching_basis po_lines.matching_basis%TYPE;
10836: l_service_po_line_id po_lines.po_line_id%TYPE;
10837: l_total_rec_quantity NUMBER;

Line 10834: l_purchase_basis po_lines.purchase_basis%TYPE;

10830: l_supply_code rcv_supply.supply_type_code%TYPE;
10831: l_transaction_type rcv_transactions.transaction_type%TYPE;
10832: /* FPJ SERVICES */
10833: l_value_basis po_lines.order_type_lookup_code%TYPE;
10834: l_purchase_basis po_lines.purchase_basis%TYPE;
10835: l_matching_basis po_lines.matching_basis%TYPE;
10836: l_service_po_line_id po_lines.po_line_id%TYPE;
10837: l_total_rec_quantity NUMBER;
10838: l_converted_distribution_qty NUMBER;

Line 10835: l_matching_basis po_lines.matching_basis%TYPE;

10831: l_transaction_type rcv_transactions.transaction_type%TYPE;
10832: /* FPJ SERVICES */
10833: l_value_basis po_lines.order_type_lookup_code%TYPE;
10834: l_purchase_basis po_lines.purchase_basis%TYPE;
10835: l_matching_basis po_lines.matching_basis%TYPE;
10836: l_service_po_line_id po_lines.po_line_id%TYPE;
10837: l_total_rec_quantity NUMBER;
10838: l_converted_distribution_qty NUMBER;
10839: l_distribution_qty NUMBER;

Line 10836: l_service_po_line_id po_lines.po_line_id%TYPE;

10832: /* FPJ SERVICES */
10833: l_value_basis po_lines.order_type_lookup_code%TYPE;
10834: l_purchase_basis po_lines.purchase_basis%TYPE;
10835: l_matching_basis po_lines.matching_basis%TYPE;
10836: l_service_po_line_id po_lines.po_line_id%TYPE;
10837: l_total_rec_quantity NUMBER;
10838: l_converted_distribution_qty NUMBER;
10839: l_distribution_qty NUMBER;
10840: l_converted_transaction_qty NUMBER;

Line 11411: from po_lines_all

11407: where po_header_id = x_po_transferrec.po_head_id;
11408:
11409: select line_num
11410: into l_po_line_num
11411: from po_lines_all
11412: where po_line_id = x_po_transferrec.po_line_id;
11413:
11414: select shipment_num
11415: into l_po_line_loc_num

Line 11478: FROM po_lines

11474: NVL(matching_basis, 'QUANTITY')
11475: INTO l_value_basis,
11476: l_purchase_basis,
11477: l_matching_basis
11478: FROM po_lines
11479: WHERE po_line_id = l_service_po_line_id;
11480:
11481: IF (l_matching_basis = 'AMOUNT') THEN
11482: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;

Line 13019: po_lines pl

13015: IF (x_cascaded_table(n).receipt_source_code = 'VENDOR') THEN --{
13016: SELECT NVL(pll.price_override, pl.unit_price)
13017: INTO x_cascaded_table(n).po_unit_price
13018: FROM po_line_locations pll,
13019: po_lines pl
13020: WHERE pll.line_location_id = x_cascaded_table(n).po_line_location_id
13021: AND pl.po_line_id = x_cascaded_table(n).po_line_id
13022: AND pl.po_line_id = pll.po_line_id;
13023:

Line 13249: FROM po_lines

13245: NVL(matching_basis, 'QUANTITY')
13246: INTO x_cascaded_table(n).value_basis,
13247: x_cascaded_table(n).purchase_basis,
13248: x_cascaded_table(n).matching_basis
13249: FROM po_lines
13250: WHERE po_line_id = x_cascaded_table(n).po_line_id;
13251: ELSE
13252: -- we require line info for receiving against services lines
13253: x_cascaded_table(n).matching_basis := 'QUANTITY';

Line 13397: po_lines pol

13393: rsl.ussgl_transaction_code
13394: FROM rcv_transactions rt,
13395: rcv_shipment_lines rsl,
13396: po_headers poh,
13397: po_lines pol
13398: WHERE rt.transaction_id = v_parent_trx_id
13399: AND rt.organization_id = NVL(v_to_organization_id, rt.organization_id)
13400: AND ( rt.transaction_type IN('RECEIVE', 'TRANSFER', 'ACCEPT', 'REJECT', 'MATCH')
13401: OR ( rt.transaction_type IN('RETURN TO VENDOR', 'RETURN TO CUSTOMER')

Line 14572: po_lines pol

14568: rsl.ussgl_transaction_code
14569: FROM rcv_transactions rt,
14570: rcv_shipment_lines rsl,
14571: po_headers poh,
14572: po_lines pol
14573: WHERE rt.transaction_id = v_parent_trx_id
14574: AND rt.organization_id = NVL(v_to_organization_id, rt.organization_id)
14575: AND ( rt.transaction_type IN('RECEIVE', 'TRANSFER', 'ACCEPT', 'REJECT', 'MATCH')
14576: OR ( rt.transaction_type IN('RETURN TO VENDOR', 'RETURN TO CUSTOMER')

Line 14935: po_lines pol

14931: */
14932: SELECT COUNT(*)
14933: INTO l_time_count
14934: FROM hxc_time_building_blocks bb,
14935: po_lines pol
14936: WHERE bb.time_building_block_id = x_cascaded_table(n).timecard_id
14937: AND bb.object_version_number = x_cascaded_table(n).timecard_ovn
14938: AND bb.SCOPE = 'TIMECARD'
14939: AND bb.resource_type = 'PERSON'

Line 15860: po_lines pl

15856: IF (x_cascaded_table(n).receipt_source_code = 'VENDOR') THEN --{
15857: SELECT NVL(pll.price_override, pl.unit_price)
15858: INTO x_cascaded_table(n).po_unit_price
15859: FROM po_line_locations pll,
15860: po_lines pl
15861: WHERE pll.line_location_id = x_cascaded_table(n).po_line_location_id
15862: AND pl.po_line_id = x_cascaded_table(n).po_line_id
15863: AND pl.po_line_id = pll.po_line_id;
15864:

Line 16874: po_lines_all pl

16870: INTO x_cascaded_table(n).value_basis,
16871: x_cascaded_table(n).matching_basis,
16872: x_cascaded_table(n).purchase_basis
16873: FROM po_line_locations_all pll,
16874: po_lines_all pl
16875: WHERE pl.po_line_id = x_cascaded_table(n).po_line_id
16876: and pl.po_line_id = pll.po_line_id
16877: and pll.line_location_id =x_cascaded_table(n).po_line_location_id;
16878: exception

Line 16917: po_lines_all pl

16913: INTO x_cascaded_table(n).value_basis,
16914: x_cascaded_table(n).matching_basis,
16915: x_cascaded_table(n).purchase_basis
16916: FROM po_line_locations_all pll,
16917: po_lines_all pl
16918: WHERE pl.po_line_id = x_cascaded_table(n).po_line_id
16919: and pl.po_line_id = pll.po_line_id
16920: and pll.shipment_num =
16921: x_cascaded_table(n).document_shipment_line_num;

Line 16969: FROM po_lines_all

16965: NVL(matching_basis, 'QUANTITY')
16966: INTO x_cascaded_table(n).value_basis,
16967: x_cascaded_table(n).purchase_basis,
16968: x_cascaded_table(n).matching_basis
16969: FROM po_lines_all
16970: WHERE po_line_id = x_cascaded_table(n).po_line_id;
16971: exception
16972: when no_data_found then
16973: IF (g_asn_debug = 'Y') THEN