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_UDA_DATA_UTIL dependencies on PO_LINE_LOCATIONS_ALL_EXT_B

Line 3814: INSERT INTO po_line_locations_all_ext_b DESTlINE

3810:
3811: IF p_draft_id > 0 THEN
3812:
3813: FORALL i IN 1..po_dest_line_location_ids_tbl.Count
3814: INSERT INTO po_line_locations_all_ext_b DESTlINE
3815: (DESTLINE.extension_id,
3816: DESTLINE.attr_group_id,
3817: DESTLINE.line_location_id,
3818: DESTLINE.data_level_id,

Line 4028: FROM po_line_locations_all_ext_b SRCLINE WHERE SRCLINE.line_location_id = po_src_line_location_id AND draft_id = -1

4024: SRCLINE.d_ext_attr9,
4025: SRCLINE.d_ext_attr10,
4026: SRCLINE.uda_template_id,
4027: SRCLINE.draft_id
4028: FROM po_line_locations_all_ext_b SRCLINE WHERE SRCLINE.line_location_id = po_src_line_location_id AND draft_id = -1
4029: AND NOT EXISTS (SELECT 1 FROM po_line_locations_all_ext_b pleb WHERE
4030: pleb.line_location_id =po_dest_line_location_ids_tbl(i) AND
4031: pleb.attr_group_id = SRCLINE.attr_group_id AND
4032: pleb.draft_id = SRCLINE.draft_id);

Line 4029: AND NOT EXISTS (SELECT 1 FROM po_line_locations_all_ext_b pleb WHERE

4025: SRCLINE.d_ext_attr10,
4026: SRCLINE.uda_template_id,
4027: SRCLINE.draft_id
4028: FROM po_line_locations_all_ext_b SRCLINE WHERE SRCLINE.line_location_id = po_src_line_location_id AND draft_id = -1
4029: AND NOT EXISTS (SELECT 1 FROM po_line_locations_all_ext_b pleb WHERE
4030: pleb.line_location_id =po_dest_line_location_ids_tbl(i) AND
4031: pleb.attr_group_id = SRCLINE.attr_group_id AND
4032: pleb.draft_id = SRCLINE.draft_id);
4033:

Line 4038: 'MERGE INTO po_line_locations_all_ext_b DESTLINE

4034: END IF ;
4035:
4036: mergeStmt := mergeStmt ||
4037:
4038: 'MERGE INTO po_line_locations_all_ext_b DESTLINE
4039: USING (
4040: SELECT
4041: attr_group_id,
4042: line_location_id,

Line 4142: FROM po_line_locations_all_ext_b WHERE line_location_id = ' || po_src_line_location_id || ' and draft_id = ' || p_draft_id || ' ) SRCLINE

4138: d_ext_attr9,
4139: d_ext_attr10,
4140: uda_template_id,
4141: draft_id
4142: FROM po_line_locations_all_ext_b WHERE line_location_id = ' || po_src_line_location_id || ' and draft_id = ' || p_draft_id || ' ) SRCLINE
4143: ON
4144: (DESTLINE.line_location_id IN (' || po_dest_line_location_ids || ') AND DESTLINE.attr_group_id = SRCLINE.attr_group_id AND DESTLINE.draft_id = '|| p_draft_id ||')
4145: WHEN MATCHED THEN
4146: UPDATE

Line 4248: INSERT INTO po_line_locations_all_ext_b DESTlINE

4244: d_progress := '30';
4245:
4246: FORALL i IN 1..po_dest_line_location_ids_tbl.Count
4247:
4248: INSERT INTO po_line_locations_all_ext_b DESTlINE
4249: (DESTLINE.extension_id,
4250: DESTLINE.attr_group_id,
4251: DESTLINE.line_location_id,
4252: DESTLINE.data_level_id,

Line 4454: FROM po_line_locations_all_ext_b SRCLINE WHERE SRCLINE.line_location_id = po_src_line_location_id AND draft_id = p_draft_id

4450: SRCLINE.d_ext_attr9,
4451: SRCLINE.d_ext_attr10,
4452: SRCLINE.uda_template_id,
4453: SRCLINE.draft_id
4454: FROM po_line_locations_all_ext_b SRCLINE WHERE SRCLINE.line_location_id = po_src_line_location_id AND draft_id = p_draft_id
4455: AND NOT EXISTS (SELECT 1 FROM po_line_locations_all_ext_b pleb WHERE
4456: pleb.line_location_id =po_dest_line_location_ids_tbl(i) AND
4457: pleb.attr_group_id = SRCLINE.attr_group_id AND
4458: pleb.draft_id = SRCLINE.draft_id);

Line 4455: AND NOT EXISTS (SELECT 1 FROM po_line_locations_all_ext_b pleb WHERE

4451: SRCLINE.d_ext_attr10,
4452: SRCLINE.uda_template_id,
4453: SRCLINE.draft_id
4454: FROM po_line_locations_all_ext_b SRCLINE WHERE SRCLINE.line_location_id = po_src_line_location_id AND draft_id = p_draft_id
4455: AND NOT EXISTS (SELECT 1 FROM po_line_locations_all_ext_b pleb WHERE
4456: pleb.line_location_id =po_dest_line_location_ids_tbl(i) AND
4457: pleb.attr_group_id = SRCLINE.attr_group_id AND
4458: pleb.draft_id = SRCLINE.draft_id);
4459:

Line 4464: FROM po_line_locations_all_ext_b

4460:
4461: --Get the ship to location to conditioonally update the ship to location
4462: SELECT SubStr(c_ext_attr13,Length('')+1,instr(c_ext_attr13,'')-(Length('')+1 )) ship_to_location_id
4463: INTO l_ship_to_loc_id
4464: FROM po_line_locations_all_ext_b
4465: WHERE line_location_id = po_src_line_location_id
4466: AND draft_id = p_draft_id;
4467:
4468: --Get all the line location ids for which ship to location is valid.

Line 4480: MERGE INTO po_line_locations_all_ext_b DESTLINE

4476: EXECUTE IMMEDIATE get_valid_line_loc_stmt BULK COLLECT INTO get_valid_line_loc_tbl;
4477:
4478: --Update the ext table for all the valid line location ids.
4479:
4480: MERGE INTO po_line_locations_all_ext_b DESTLINE
4481: USING (
4482: SELECT
4483: line_location_id,
4484: attr_group_id,

Line 4495: FROM po_line_locations_all_ext_b WHERE line_location_id = po_src_line_location_id and draft_id = p_draft_id ) SRCLINE

4491: c_ext_attr10,
4492: c_ext_attr11,
4493: c_ext_attr12,
4494: c_ext_attr13
4495: FROM po_line_locations_all_ext_b WHERE line_location_id = po_src_line_location_id and draft_id = p_draft_id ) SRCLINE
4496: ON
4497: (DESTLINE.line_location_id IN (SELECT column_value FROM TABLE(get_valid_line_loc_tbl) ) AND DESTLINE.attr_group_id = SRCLINE.attr_group_id AND DESTLINE.draft_id = p_draft_id )
4498: WHEN MATCHED THEN
4499: UPDATE

Line 4515: FROM po_line_locations_all_ext_b

4511:
4512: d_progress := '40';
4513: selectStmt := selectStmt ||
4514: ' SELECT extension_id,attr_group_id,line_location_id,data_level_id,uda_template_id
4515: FROM po_line_locations_all_ext_b
4516: WHERE line_location_id IN ( ' || po_dest_line_location_ids || ') AND draft_id = '|| p_draft_id;
4517:
4518: d_progress := '50';
4519:

Line 4567: DELETE FROM po_line_locations_all_ext_b WHERE line_location_id = po_src_line_location_id AND draft_id = p_draft_id;

4563: AND pltl.LANGUAGE = L.LANGUAGE_CODE);
4564:
4565: d_progress := '70';
4566:
4567: DELETE FROM po_line_locations_all_ext_b WHERE line_location_id = po_src_line_location_id AND draft_id = p_draft_id;
4568:
4569: d_progress := '80';
4570:
4571: EXCEPTION

Line 4766: g_object_dff_tl('PO_SHIPMENTS_EXT_ATTRS').l_object_ext_b_table := 'PO_LINE_LOCATIONS_ALL_EXT_B';

4762: g_object_dff_tl('PO_LINE_EXT_ATTRS').l_arch_object_name := 'PO_LINES_ARCHIVE_ALL' ;
4763:
4764: g_object_dff_tl('PO_SHIPMENTS_EXT_ATTRS').l_object_name := 'PO_LINE_LOCATIONS_ALL' ;
4765: g_object_dff_tl('PO_SHIPMENTS_EXT_ATTRS').l_dff_name := 'PO_SHIPMENTS_EXT_ATTRS';
4766: g_object_dff_tl('PO_SHIPMENTS_EXT_ATTRS').l_object_ext_b_table := 'PO_LINE_LOCATIONS_ALL_EXT_B';
4767: g_object_dff_tl('PO_SHIPMENTS_EXT_ATTRS').l_object_ext_tl_table := 'PO_LINE_LOCATIONS_ALL_EXT_TL';
4768: g_object_dff_tl('PO_SHIPMENTS_EXT_ATTRS').l_ag_mapping_column := 'PO_SHIPMENTS_GROUP_ID';
4769: g_object_dff_tl('PO_SHIPMENTS_EXT_ATTRS').l_arch_object_name := 'PO_LINE_LOCATIONS_ARCHIVE_ALL' ;
4770: