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.PO_PDOI_ATTR_PROCESS_PVT dependencies on PO_PDOI_PARAMS

Line 78: AND intf_attrs.processing_id = PO_PDOI_PARAMS.g_processing_id

74: WHERE intf_attrs.interface_line_id = intf_lines.interface_line_id
75: AND intf_lines.interface_header_id = intf_headers.interface_header_id
76: AND intf_headers.draft_id = draft_lines.draft_id
77: AND intf_lines.po_line_id = draft_lines.po_line_id
78: AND intf_attrs.processing_id = PO_PDOI_PARAMS.g_processing_id
79: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
80: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
81: AND intf_attrs.interface_attr_values_id > p_max_intf_attr_values_id
82: AND NVL(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)

Line 79: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

75: AND intf_lines.interface_header_id = intf_headers.interface_header_id
76: AND intf_headers.draft_id = draft_lines.draft_id
77: AND intf_lines.po_line_id = draft_lines.po_line_id
78: AND intf_attrs.processing_id = PO_PDOI_PARAMS.g_processing_id
79: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
80: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
81: AND intf_attrs.interface_attr_values_id > p_max_intf_attr_values_id
82: AND NVL(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
83: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED

Line 80: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id

76: AND intf_headers.draft_id = draft_lines.draft_id
77: AND intf_lines.po_line_id = draft_lines.po_line_id
78: AND intf_attrs.processing_id = PO_PDOI_PARAMS.g_processing_id
79: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
80: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
81: AND intf_attrs.interface_attr_values_id > p_max_intf_attr_values_id
82: AND NVL(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
83: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
84: ORDER BY intf_attrs.interface_attr_values_id;

Line 447: AND intf_attrs_tlp.processing_id = PO_PDOI_PARAMS.g_processing_id

443: WHERE intf_attrs_tlp.interface_line_id = intf_lines.interface_line_id
444: AND intf_lines.interface_header_id = intf_headers.interface_header_id
445: AND intf_headers.draft_id = draft_lines.draft_id
446: AND intf_lines.po_line_id = draft_lines.po_line_id
447: AND intf_attrs_tlp.processing_id = PO_PDOI_PARAMS.g_processing_id
448: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
449: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
450: AND intf_attrs_tlp.interface_attr_values_tlp_id > p_max_intf_attr_values_tlp_id
451: AND NVL(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)

Line 448: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

444: AND intf_lines.interface_header_id = intf_headers.interface_header_id
445: AND intf_headers.draft_id = draft_lines.draft_id
446: AND intf_lines.po_line_id = draft_lines.po_line_id
447: AND intf_attrs_tlp.processing_id = PO_PDOI_PARAMS.g_processing_id
448: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
449: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
450: AND intf_attrs_tlp.interface_attr_values_tlp_id > p_max_intf_attr_values_tlp_id
451: AND NVL(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
452: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED

Line 449: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id

445: AND intf_headers.draft_id = draft_lines.draft_id
446: AND intf_lines.po_line_id = draft_lines.po_line_id
447: AND intf_attrs_tlp.processing_id = PO_PDOI_PARAMS.g_processing_id
448: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
449: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
450: AND intf_attrs_tlp.interface_attr_values_tlp_id > p_max_intf_attr_values_tlp_id
451: AND NVL(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
452: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
453: ORDER BY intf_attrs_tlp.interface_attr_values_tlp_id;

Line 851: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id

847: po_headers_draft_all draft_headers,
848: po_headers_all txn_headers,
849: mtl_system_items_b msi -- Bug7039409: Added to get lead time
850: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
851: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
852: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
853: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
854: AND intf_lines.action = PO_PDOI_CONSTANTS.g_ACTION_ADD
855: AND intf_lines.po_line_id = draft_lines.po_line_id

Line 852: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id

848: po_headers_all txn_headers,
849: mtl_system_items_b msi -- Bug7039409: Added to get lead time
850: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
851: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
852: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
853: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
854: AND intf_lines.action = PO_PDOI_CONSTANTS.g_ACTION_ADD
855: AND intf_lines.po_line_id = draft_lines.po_line_id
856: AND intf_headers.draft_id = draft_lines.draft_id

Line 853: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

849: mtl_system_items_b msi -- Bug7039409: Added to get lead time
850: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
851: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
852: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
853: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
854: AND intf_lines.action = PO_PDOI_CONSTANTS.g_ACTION_ADD
855: AND intf_lines.po_line_id = draft_lines.po_line_id
856: AND intf_headers.draft_id = draft_lines.draft_id
857: AND draft_lines.po_header_id = draft_headers.po_header_id(+)

Line 916: PO_PDOI_PARAMS.g_request.org_id,

912: '-2', -- REQ_TEMPLATE_NAME
913: -2, --REQ_TEMPLATE_LINE_NUM
914: NVL(l_ip_category_id_tbl(i), -2),
915: NVL(l_item_id_tbl(i), -2),
916: PO_PDOI_PARAMS.g_request.org_id,
917: l_lead_time_tbl(i), -- Bug7039409: LEAD_TIME
918: FND_GLOBAL.login_id,
919: FND_GLOBAL.user_id,
920: sysdate,

Line 964: PO_PDOI_PARAMS.g_request.org_id,

960: '-2', -- REQ_TEMPLATE_NAME
961: -2, --REQ_TEMPLATE_LINE_NUM
962: NVL(l_ip_category_id_tbl(i), -2),
963: NVL(l_item_id_tbl(i), -2),
964: PO_PDOI_PARAMS.g_request.org_id,
965: l_created_lang_tbl(i),
966: l_item_desc_tbl(i),
967: FND_GLOBAL.login_id,
968: FND_GLOBAL.user_id,