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.

[Home] [Help]

APPS.PORCPTWF dependencies on POR_CONFIRM_INTERNAL_RECEIPT_V

Line 615: FROM POR_CONFIRM_INTERNAL_RECEIPT_V

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

Line 634: FROM POR_CONFIRM_INTERNAL_RECEIPT_V

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

Line 767: FROM POR_CONFIRM_INTERNAL_RECEIPT_V

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

Line 783: FROM POR_CONFIRM_INTERNAL_RECEIPT_V

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

Line 2461: FROM POR_CONFIRM_INTERNAL_RECEIPT_V

2457:
2458: if x_allow_inv_dest_receipts = 'N' then
2459: SELECT COUNT(*) INTO
2460: X_COUNT
2461: FROM POR_CONFIRM_INTERNAL_RECEIPT_V
2462: WHERE expected_receipt_date is not NULL
2463: AND expected_receipt_date = x_exp_receipt_date
2464: AND NVL(receipt_required_flag,'N') = 'Y'
2465: AND destination_type_code = 'EXPENSE'

Line 2473: FROM POR_CONFIRM_INTERNAL_RECEIPT_V

2469: AND requestor_ID = x_requester_id;
2470: else
2471: SELECT COUNT(*)
2472: INTO X_COUNT
2473: FROM POR_CONFIRM_INTERNAL_RECEIPT_V
2474: WHERE expected_receipt_date is not NULL
2475: AND expected_receipt_date = x_exp_receipt_date
2476: AND NVL(receipt_required_flag,'N') = 'Y'
2477: AND requestor_ID is not NULL

Line 2901: FROM POR_CONFIRM_INTERNAL_RECEIPT_V

2897: TO_ORGANIZATION_ID,
2898: COMMENTS,
2899: PACKING_SLIP,
2900: WAYBILL_AIRBILL_NUM
2901: FROM POR_CONFIRM_INTERNAL_RECEIPT_V
2902: WHERE expected_receipt_date is not NULL
2903: AND expected_receipt_date = x_exp_receipt_date
2904: AND destination_type_code = 'EXPENSE'
2905: AND requestor_id is not NULL

Line 2920: FROM POR_CONFIRM_INTERNAL_RECEIPT_V

2916: TO_ORGANIZATION_ID,
2917: COMMENTS,
2918: PACKING_SLIP,
2919: WAYBILL_AIRBILL_NUM
2920: FROM POR_CONFIRM_INTERNAL_RECEIPT_V
2921: WHERE expected_receipt_date is not NULL
2922: AND expected_receipt_date = x_exp_receipt_date
2923: AND requestor_id is not NULL
2924: AND expected_receipt_qty > 0

Line 3001: FROM POR_CONFIRM_INTERNAL_RECEIPT_V

2997:
2998: if (x_allow_inv_dest_receipts = 'N') then
2999: SELECT count(*)
3000: INTO x_tmp_count
3001: FROM POR_CONFIRM_INTERNAL_RECEIPT_V
3002: WHERE expected_receipt_date is not NULL
3003: AND NVL(receipt_required_flag,'N') = 'Y'
3004: AND destination_type_code = 'EXPENSE'
3005: AND requestor_id is not NULL

Line 3010: FROM POR_CONFIRM_INTERNAL_RECEIPT_V

3006: AND so_header_ID = x_header_ID;
3007:
3008: SELECT count(*)
3009: INTO x_tmp_count1
3010: FROM POR_CONFIRM_INTERNAL_RECEIPT_V
3011: WHERE expected_receipt_date is not NULL
3012: AND expected_receipt_date = x_exp_receipt_date
3013: AND NVL(receipt_required_flag,'N') = 'Y'
3014: AND destination_type_code = 'EXPENSE'

Line 3022: FROM POR_CONFIRM_INTERNAL_RECEIPT_V

3018: AND requestor_ID = x_requester_id;
3019: else
3020: SELECT count(*)
3021: INTO x_tmp_count
3022: FROM POR_CONFIRM_INTERNAL_RECEIPT_V
3023: WHERE expected_receipt_date is not NULL
3024: AND NVL(receipt_required_flag,'N') = 'Y'
3025: AND requestor_id is not NULL
3026: AND so_header_ID = x_header_ID;

Line 3030: FROM POR_CONFIRM_INTERNAL_RECEIPT_V

3026: AND so_header_ID = x_header_ID;
3027:
3028: SELECT count(*)
3029: INTO x_tmp_count1
3030: FROM POR_CONFIRM_INTERNAL_RECEIPT_V
3031: WHERE expected_receipt_date is not NULL
3032: AND expected_receipt_date = x_exp_receipt_date
3033: AND NVL(receipt_required_flag,'N') = 'Y'
3034: AND requestor_id is not NULL

Line 3249: FROM POR_CONFIRM_INTERNAL_RECEIPT_V

3245: item_description,
3246: currency_code,
3247: unit_price,
3248: req_number
3249: FROM POR_CONFIRM_INTERNAL_RECEIPT_V
3250: WHERE expected_receipt_date is not NULL
3251: AND trunc(expected_receipt_date) = trunc(x_exp_receipt_date)
3252: AND NVL(receipt_required_flag,'N') = 'Y'
3253: AND destination_type_code = 'EXPENSE'

Line 3271: FROM POR_CONFIRM_INTERNAL_RECEIPT_V

3267: item_description,
3268: currency_code,
3269: unit_price,
3270: req_number
3271: FROM POR_CONFIRM_INTERNAL_RECEIPT_V
3272: WHERE expected_receipt_date is not NULL
3273: AND trunc(expected_receipt_date) = trunc(x_exp_receipt_date)
3274: AND NVL(receipt_required_flag,'N') = 'Y'
3275: AND requestor_ID is not NULL