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 451: AND intf_attrs_tlp.processing_id = PO_PDOI_PARAMS.g_processing_id

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

Line 452: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

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

Line 453: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id

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

Line 859: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id

855: po_headers_draft_all draft_headers,
856: po_headers_all txn_headers,
857: mtl_system_items_b msi -- Bug7039409: Added to get lead time
858: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
859: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
860: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
861: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
862: AND intf_lines.action = PO_PDOI_CONSTANTS.g_ACTION_ADD
863: AND intf_lines.po_line_id = draft_lines.po_line_id

Line 860: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id

856: po_headers_all txn_headers,
857: mtl_system_items_b msi -- Bug7039409: Added to get lead time
858: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
859: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
860: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
861: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
862: AND intf_lines.action = PO_PDOI_CONSTANTS.g_ACTION_ADD
863: AND intf_lines.po_line_id = draft_lines.po_line_id
864: AND intf_headers.draft_id = draft_lines.draft_id

Line 861: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

857: mtl_system_items_b msi -- Bug7039409: Added to get lead time
858: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
859: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
860: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
861: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
862: AND intf_lines.action = PO_PDOI_CONSTANTS.g_ACTION_ADD
863: AND intf_lines.po_line_id = draft_lines.po_line_id
864: AND intf_headers.draft_id = draft_lines.draft_id
865: AND draft_lines.po_header_id = draft_headers.po_header_id(+)

Line 924: PO_PDOI_PARAMS.g_request.org_id,

920: '-2', -- REQ_TEMPLATE_NAME
921: -2, --REQ_TEMPLATE_LINE_NUM
922: NVL(l_ip_category_id_tbl(i), -2),
923: NVL(l_item_id_tbl(i), -2),
924: PO_PDOI_PARAMS.g_request.org_id,
925: l_lead_time_tbl(i), -- Bug7039409: LEAD_TIME
926: FND_GLOBAL.login_id,
927: FND_GLOBAL.user_id,
928: sysdate,

Line 972: PO_PDOI_PARAMS.g_request.org_id,

968: '-2', -- REQ_TEMPLATE_NAME
969: -2, --REQ_TEMPLATE_LINE_NUM
970: NVL(l_ip_category_id_tbl(i), -2),
971: NVL(l_item_id_tbl(i), -2),
972: PO_PDOI_PARAMS.g_request.org_id,
973: l_created_lang_tbl(i),
974: l_item_desc_tbl(i),
975: FND_GLOBAL.login_id,
976: FND_GLOBAL.user_id,