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_ATTRIBUTE_VALUES_TLP

Line 634: FROM po_attribute_values_tlp_draft

630: SELECT l_key,
631: x_processing_row_tbl(i),
632: attribute_values_tlp_id,
633: 'DRAFT'
634: FROM po_attribute_values_tlp_draft
635: WHERE draft_id = x_attr_values_tlp.draft_id_tbl(i)
636: AND po_line_id = x_attr_values_tlp.ln_po_line_id_tbl(i)
637: AND language = x_attr_values_tlp.language_tbl(i)
638: AND org_id = x_attr_values_tlp.org_id_tbl(i);

Line 654: FROM po_attribute_values_tlp

650: SELECT l_key,
651: x_processing_row_tbl(i),
652: attribute_values_tlp_id,
653: 'TXN'
654: FROM po_attribute_values_tlp
655: WHERE po_line_id = x_attr_values_tlp.ln_po_line_id_tbl(i)
656: AND language = x_attr_values_tlp.language_tbl(i)
657: AND org_id = x_attr_values_tlp.org_id_tbl(i);
658: END IF;

Line 933: INSERT INTO po_attribute_values_tlp_draft

929: d_position := 20;
930:
931: -- create default attr_tlp rows in document created languages
932: FORALL i IN 1..l_draft_id_tbl.COUNT
933: INSERT INTO po_attribute_values_tlp_draft
934: (
935: ATTRIBUTE_VALUES_TLP_ID,
936: DRAFT_ID,
937: PO_LINE_ID,

Line 957: PO_ATTRIBUTE_VALUES_TLP_S.nextval,

953: PROGRAM_UPDATE_DATE
954: )
955: VALUES
956: (
957: PO_ATTRIBUTE_VALUES_TLP_S.nextval,
958: l_draft_id_tbl(i),
959: l_po_line_id_tbl(i),
960: '-2', -- REQ_TEMPLATE_NAME
961: -2, --REQ_TEMPLATE_LINE_NUM

Line 1014: -- Bug7039409: update po_attribute_values_tlp_draft.manufacturer

1010: AND request_id = fnd_global.conc_request_id
1011: AND program_application_id = fnd_global.prog_appl_id
1012: AND program_id = fnd_global.conc_program_id;
1013:
1014: -- Bug7039409: update po_attribute_values_tlp_draft.manufacturer
1015: FORALL i IN 1..l_item_id_tbl2.COUNT
1016: UPDATE po_attribute_values_tlp_draft
1017: SET manufacturer = l_mfg_name_tbl(i)
1018: WHERE inventory_item_id = l_item_id_tbl2(i)

Line 1016: UPDATE po_attribute_values_tlp_draft

1012: AND program_id = fnd_global.conc_program_id;
1013:
1014: -- Bug7039409: update po_attribute_values_tlp_draft.manufacturer
1015: FORALL i IN 1..l_item_id_tbl2.COUNT
1016: UPDATE po_attribute_values_tlp_draft
1017: SET manufacturer = l_mfg_name_tbl(i)
1018: WHERE inventory_item_id = l_item_id_tbl2(i)
1019: AND org_id = l_master_org_id
1020: AND request_id = fnd_global.conc_request_id

Line 1024: -- Bug7039409: update po_attribute_values_tlp_draft.long_description

1020: AND request_id = fnd_global.conc_request_id
1021: AND program_application_id = fnd_global.prog_appl_id
1022: AND program_id = fnd_global.conc_program_id;
1023:
1024: -- Bug7039409: update po_attribute_values_tlp_draft.long_description
1025: UPDATE po_attribute_values_tlp_draft pavd_tlp
1026: SET long_description = (SELECT long_description
1027: FROM mtl_system_items_tl msi_tl,
1028: fnd_languages lang

Line 1025: UPDATE po_attribute_values_tlp_draft pavd_tlp

1021: AND program_application_id = fnd_global.prog_appl_id
1022: AND program_id = fnd_global.conc_program_id;
1023:
1024: -- Bug7039409: update po_attribute_values_tlp_draft.long_description
1025: UPDATE po_attribute_values_tlp_draft pavd_tlp
1026: SET long_description = (SELECT long_description
1027: FROM mtl_system_items_tl msi_tl,
1028: fnd_languages lang
1029: WHERE msi_tl.inventory_item_id = pavd_tlp.inventory_item_id