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.PORCPTWF dependencies on POR_CONFIRM_INTERNAL_RECEIPT_V

Line 613: FROM POR_CONFIRM_INTERNAL_RECEIPT_V

609: TO_ORGANIZATION_ID,
610: COMMENTS,
611: PACKING_SLIP,
612: WAYBILL_AIRBILL_NUM
613: FROM POR_CONFIRM_INTERNAL_RECEIPT_V
614: WHERE expected_receipt_date is not NULL
615: AND expected_receipt_date = x_exp_receipt_date
616: AND destination_type_code = 'EXPENSE'
617: AND requestor_id is not NULL

Line 632: FROM POR_CONFIRM_INTERNAL_RECEIPT_V

628: TO_ORGANIZATION_ID,
629: COMMENTS,
630: PACKING_SLIP,
631: WAYBILL_AIRBILL_NUM
632: FROM POR_CONFIRM_INTERNAL_RECEIPT_V
633: WHERE expected_receipt_date is not NULL
634: AND expected_receipt_date = x_exp_receipt_date
635: AND requestor_id is not NULL
636: AND expected_receipt_qty > 0

Line 765: FROM POR_CONFIRM_INTERNAL_RECEIPT_V

761: requestor_ID,
762: expected_receipt_date,
763: requisition_line_ID,
764: requisition_header_ID
765: FROM POR_CONFIRM_INTERNAL_RECEIPT_V
766: WHERE expected_receipt_date is not NULL
767: AND trunc(expected_receipt_date + 1) <= trunc(SYSDATE)
768: AND destination_type_code = 'EXPENSE'
769: AND requestor_ID is not NULL

Line 781: FROM POR_CONFIRM_INTERNAL_RECEIPT_V

777: requestor_ID,
778: expected_receipt_date,
779: requisition_line_ID,
780: requisition_header_ID
781: FROM POR_CONFIRM_INTERNAL_RECEIPT_V
782: WHERE expected_receipt_date is not NULL
783: AND trunc(expected_receipt_date + 1) <= trunc(SYSDATE)
784: AND requestor_ID is not NULL
785: AND expected_receipt_qty > 0

Line 2455: FROM POR_CONFIRM_INTERNAL_RECEIPT_V

2451:
2452: if x_allow_inv_dest_receipts = 'N' then
2453: SELECT COUNT(*) INTO
2454: X_COUNT
2455: FROM POR_CONFIRM_INTERNAL_RECEIPT_V
2456: WHERE expected_receipt_date is not NULL
2457: AND expected_receipt_date = x_exp_receipt_date
2458: AND NVL(receipt_required_flag,'N') = 'Y'
2459: AND destination_type_code = 'EXPENSE'

Line 2467: FROM POR_CONFIRM_INTERNAL_RECEIPT_V

2463: AND requestor_ID = x_requester_id;
2464: else
2465: SELECT COUNT(*)
2466: INTO X_COUNT
2467: FROM POR_CONFIRM_INTERNAL_RECEIPT_V
2468: WHERE expected_receipt_date is not NULL
2469: AND expected_receipt_date = x_exp_receipt_date
2470: AND NVL(receipt_required_flag,'N') = 'Y'
2471: AND requestor_ID is not NULL

Line 2856: FROM POR_CONFIRM_INTERNAL_RECEIPT_V

2852: TO_ORGANIZATION_ID,
2853: COMMENTS,
2854: PACKING_SLIP,
2855: WAYBILL_AIRBILL_NUM
2856: FROM POR_CONFIRM_INTERNAL_RECEIPT_V
2857: WHERE expected_receipt_date is not NULL
2858: AND expected_receipt_date = x_exp_receipt_date
2859: AND destination_type_code = 'EXPENSE'
2860: AND requestor_id is not NULL

Line 2875: FROM POR_CONFIRM_INTERNAL_RECEIPT_V

2871: TO_ORGANIZATION_ID,
2872: COMMENTS,
2873: PACKING_SLIP,
2874: WAYBILL_AIRBILL_NUM
2875: FROM POR_CONFIRM_INTERNAL_RECEIPT_V
2876: WHERE expected_receipt_date is not NULL
2877: AND expected_receipt_date = x_exp_receipt_date
2878: AND requestor_id is not NULL
2879: AND expected_receipt_qty > 0

Line 2956: FROM POR_CONFIRM_INTERNAL_RECEIPT_V

2952:
2953: if (x_allow_inv_dest_receipts = 'N') then
2954: SELECT count(*)
2955: INTO x_tmp_count
2956: FROM POR_CONFIRM_INTERNAL_RECEIPT_V
2957: WHERE expected_receipt_date is not NULL
2958: AND NVL(receipt_required_flag,'N') = 'Y'
2959: AND destination_type_code = 'EXPENSE'
2960: AND requestor_id is not NULL

Line 2965: FROM POR_CONFIRM_INTERNAL_RECEIPT_V

2961: AND so_header_ID = x_header_ID;
2962:
2963: SELECT count(*)
2964: INTO x_tmp_count1
2965: FROM POR_CONFIRM_INTERNAL_RECEIPT_V
2966: WHERE expected_receipt_date is not NULL
2967: AND expected_receipt_date = x_exp_receipt_date
2968: AND NVL(receipt_required_flag,'N') = 'Y'
2969: AND destination_type_code = 'EXPENSE'

Line 2977: FROM POR_CONFIRM_INTERNAL_RECEIPT_V

2973: AND requestor_ID = x_requester_id;
2974: else
2975: SELECT count(*)
2976: INTO x_tmp_count
2977: FROM POR_CONFIRM_INTERNAL_RECEIPT_V
2978: WHERE expected_receipt_date is not NULL
2979: AND NVL(receipt_required_flag,'N') = 'Y'
2980: AND requestor_id is not NULL
2981: AND so_header_ID = x_header_ID;

Line 2985: FROM POR_CONFIRM_INTERNAL_RECEIPT_V

2981: AND so_header_ID = x_header_ID;
2982:
2983: SELECT count(*)
2984: INTO x_tmp_count1
2985: FROM POR_CONFIRM_INTERNAL_RECEIPT_V
2986: WHERE expected_receipt_date is not NULL
2987: AND expected_receipt_date = x_exp_receipt_date
2988: AND NVL(receipt_required_flag,'N') = 'Y'
2989: AND requestor_id is not NULL

Line 3204: FROM POR_CONFIRM_INTERNAL_RECEIPT_V

3200: item_description,
3201: currency_code,
3202: unit_price,
3203: req_number
3204: FROM POR_CONFIRM_INTERNAL_RECEIPT_V
3205: WHERE expected_receipt_date is not NULL
3206: AND trunc(expected_receipt_date) = trunc(x_exp_receipt_date)
3207: AND NVL(receipt_required_flag,'N') = 'Y'
3208: AND destination_type_code = 'EXPENSE'

Line 3226: FROM POR_CONFIRM_INTERNAL_RECEIPT_V

3222: item_description,
3223: currency_code,
3224: unit_price,
3225: req_number
3226: FROM POR_CONFIRM_INTERNAL_RECEIPT_V
3227: WHERE expected_receipt_date is not NULL
3228: AND trunc(expected_receipt_date) = trunc(x_exp_receipt_date)
3229: AND NVL(receipt_required_flag,'N') = 'Y'
3230: AND requestor_ID is not NULL