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_CREATE_ISO dependencies on PO_REQUISITION_LINES

Line 35: Step 1: Set transferred_to_oe_flag to 'I' in po_requisition_lines

31: Args: None
32: Reqs:
33: Mods:
34: Algr:
35: Step 1: Set transferred_to_oe_flag to 'I' in po_requisition_lines
36: for all Reqs that are approved and have atleast one line with
37: source_type as INVENTORY.
38: Step 2: Open the Cursor that has all headers with TRANSFERRED_TO_OE_FLAG
39: as I.

Line 45: insert into oe_lines_iface_all from po_requisition_lines

41: If no detail found, set the transferred_to_oe_flag to 'E'
42: for those headers.
43: Step 4: insert into oe_headers_iface_all from po_requisition_headers
44: Step 5: For each row
45: insert into oe_lines_iface_all from po_requisition_lines
46: Step 6: Update the transferred_to_oe_flag to 'Y' for all 'I' ones and
47: to 'N' for all 'E' ones.
48: Step 7: return
49: ==============================================================================*/

Line 75: l_dest_type_code PO_REQUISITION_LINES.destination_type_code%TYPE;

71:
72: -- Bug 2873877 START
73: l_val_proj_result VARCHAR(1);
74: l_val_proj_error_code VARCHAR2(80);
75: l_dest_type_code PO_REQUISITION_LINES.destination_type_code%TYPE;
76: l_source_org_id PO_REQUISITION_LINES.source_organization_id%TYPE;
77: l_need_by_date PO_REQUISITION_LINES.need_by_date%TYPE;
78: l_project_id PO_REQ_DISTRIBUTIONS.project_id%TYPE;
79: l_task_id PO_REQ_DISTRIBUTIONS.task_id%TYPE;

Line 76: l_source_org_id PO_REQUISITION_LINES.source_organization_id%TYPE;

72: -- Bug 2873877 START
73: l_val_proj_result VARCHAR(1);
74: l_val_proj_error_code VARCHAR2(80);
75: l_dest_type_code PO_REQUISITION_LINES.destination_type_code%TYPE;
76: l_source_org_id PO_REQUISITION_LINES.source_organization_id%TYPE;
77: l_need_by_date PO_REQUISITION_LINES.need_by_date%TYPE;
78: l_project_id PO_REQ_DISTRIBUTIONS.project_id%TYPE;
79: l_task_id PO_REQ_DISTRIBUTIONS.task_id%TYPE;
80: -- Bug 2873877 END

Line 77: l_need_by_date PO_REQUISITION_LINES.need_by_date%TYPE;

73: l_val_proj_result VARCHAR(1);
74: l_val_proj_error_code VARCHAR2(80);
75: l_dest_type_code PO_REQUISITION_LINES.destination_type_code%TYPE;
76: l_source_org_id PO_REQUISITION_LINES.source_organization_id%TYPE;
77: l_need_by_date PO_REQUISITION_LINES.need_by_date%TYPE;
78: l_project_id PO_REQ_DISTRIBUTIONS.project_id%TYPE;
79: l_task_id PO_REQ_DISTRIBUTIONS.task_id%TYPE;
80: -- Bug 2873877 END
81:

Line 83: l_dest_secondary_quantity PO_REQUISITION_LINES.SECONDARY_QUANTITY%TYPE := NULL;

79: l_task_id PO_REQ_DISTRIBUTIONS.task_id%TYPE;
80: -- Bug 2873877 END
81:
82: --
83: l_dest_secondary_quantity PO_REQUISITION_LINES.SECONDARY_QUANTITY%TYPE := NULL;
84: l_dest_secondary_unit PO_REQUISITION_LINES.SECONDARY_UNIT_OF_MEASURE%TYPE := NULL;
85: l_item_id PO_REQUISITION_LINES.ITEM_ID%TYPE := NULL;
86: l_source_secondary_quantity PO_REQUISITION_LINES.SECONDARY_QUANTITY%TYPE := NULL;
87: l_source_secondary_uom MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE := NULL;

Line 84: l_dest_secondary_unit PO_REQUISITION_LINES.SECONDARY_UNIT_OF_MEASURE%TYPE := NULL;

80: -- Bug 2873877 END
81:
82: --
83: l_dest_secondary_quantity PO_REQUISITION_LINES.SECONDARY_QUANTITY%TYPE := NULL;
84: l_dest_secondary_unit PO_REQUISITION_LINES.SECONDARY_UNIT_OF_MEASURE%TYPE := NULL;
85: l_item_id PO_REQUISITION_LINES.ITEM_ID%TYPE := NULL;
86: l_source_secondary_quantity PO_REQUISITION_LINES.SECONDARY_QUANTITY%TYPE := NULL;
87: l_source_secondary_uom MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE := NULL;
88: l_source_secondary_unit PO_REQUISITION_LINES.SECONDARY_UNIT_OF_MEASURE%TYPE := NULL;

Line 85: l_item_id PO_REQUISITION_LINES.ITEM_ID%TYPE := NULL;

81:
82: --
83: l_dest_secondary_quantity PO_REQUISITION_LINES.SECONDARY_QUANTITY%TYPE := NULL;
84: l_dest_secondary_unit PO_REQUISITION_LINES.SECONDARY_UNIT_OF_MEASURE%TYPE := NULL;
85: l_item_id PO_REQUISITION_LINES.ITEM_ID%TYPE := NULL;
86: l_source_secondary_quantity PO_REQUISITION_LINES.SECONDARY_QUANTITY%TYPE := NULL;
87: l_source_secondary_uom MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE := NULL;
88: l_source_secondary_unit PO_REQUISITION_LINES.SECONDARY_UNIT_OF_MEASURE%TYPE := NULL;
89: --

Line 86: l_source_secondary_quantity PO_REQUISITION_LINES.SECONDARY_QUANTITY%TYPE := NULL;

82: --
83: l_dest_secondary_quantity PO_REQUISITION_LINES.SECONDARY_QUANTITY%TYPE := NULL;
84: l_dest_secondary_unit PO_REQUISITION_LINES.SECONDARY_UNIT_OF_MEASURE%TYPE := NULL;
85: l_item_id PO_REQUISITION_LINES.ITEM_ID%TYPE := NULL;
86: l_source_secondary_quantity PO_REQUISITION_LINES.SECONDARY_QUANTITY%TYPE := NULL;
87: l_source_secondary_uom MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE := NULL;
88: l_source_secondary_unit PO_REQUISITION_LINES.SECONDARY_UNIT_OF_MEASURE%TYPE := NULL;
89: --
90:

Line 88: l_source_secondary_unit PO_REQUISITION_LINES.SECONDARY_UNIT_OF_MEASURE%TYPE := NULL;

84: l_dest_secondary_unit PO_REQUISITION_LINES.SECONDARY_UNIT_OF_MEASURE%TYPE := NULL;
85: l_item_id PO_REQUISITION_LINES.ITEM_ID%TYPE := NULL;
86: l_source_secondary_quantity PO_REQUISITION_LINES.SECONDARY_QUANTITY%TYPE := NULL;
87: l_source_secondary_uom MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE := NULL;
88: l_source_secondary_unit PO_REQUISITION_LINES.SECONDARY_UNIT_OF_MEASURE%TYPE := NULL;
89: --
90:
91: l_pjm_ou_id FINANCIALS_SYSTEM_PARAMS_ALL.org_id%TYPE; --< Bug 3265539 >
92:

Line 121: l_org_id PO_REQUISITION_LINES.org_id%TYPE;

117: l_dest_currency_code VARCHAR2(15);
118: --BUG10037733
119:
120: --#bug 12816938 variable definitions.
121: l_org_id PO_REQUISITION_LINES.org_id%TYPE;
122:
123: /* Bug# 1644637
124: Added conditions in where clause to check if the Line is INVENTORY sourced
125: and the line is not Cancelled or FINALLY CLOSED.

Line 142: from po_requisition_lines lin,

138: from PO_LOCATION_ASSOCIATIONS_ALL PLA
139: where pla.location_id = lin.deliver_to_location_id
140: AND nvl(PLA.ORG_ID,-1) = nvl(org.operating_unit,-1)
141: AND rownum=1),-1) customer_id --bug 8692047
142: from po_requisition_lines lin,
143: po_requisition_headers hdr,
144: org_organization_definitions org
145: where lin.requisition_header_id = hdr.requisition_header_id
146: and lin.source_organization_id = org.organization_id

Line 181: from po_requisition_lines prl

177: SET PRH.TRANSFERRED_TO_OE_FLAG = 'I'
178: WHERE nvl(PRH.TRANSFERRED_TO_OE_FLAG,'N') = 'N'
179: AND PRH.AUTHORIZATION_STATUS = 'APPROVED'
180: AND exists (select /*+ HASH_SJ */ /*'At least one inventory sourced line'
181: from po_requisition_lines prl
182: where prh.requisition_header_id =
183: prl.requisition_header_id
184: and prl.source_type_code = 'INVENTORY'
185: and nvl(prl.cancel_flag,'N') = 'N'

Line 194: AND prh.requisition_header_id IN (SELECT /+ index ( PRL po_requisition_lines_f5 ) /

190:
191: UPDATE po_requisition_headers prh
192: SET prh.transferred_to_oe_flag = 'I'
193: WHERE prh.authorization_status = 'APPROVED'
194: AND prh.requisition_header_id IN (SELECT /*+ index ( PRL po_requisition_lines_f5 ) */
195: DISTINCT prl.requisition_header_id
196: FROM po_requisition_lines prl
197: WHERE Nvl(prl.line_location_id,- 999) = - 999
198: AND prl.source_type_code = 'INVENTORY'

Line 196: FROM po_requisition_lines prl

192: SET prh.transferred_to_oe_flag = 'I'
193: WHERE prh.authorization_status = 'APPROVED'
194: AND prh.requisition_header_id IN (SELECT /*+ index ( PRL po_requisition_lines_f5 ) */
195: DISTINCT prl.requisition_header_id
196: FROM po_requisition_lines prl
197: WHERE Nvl(prl.line_location_id,- 999) = - 999
198: AND prl.source_type_code = 'INVENTORY'
199: AND Nvl(prl.transferred_to_oe_flag,'N') = 'N' --Bug7699084
200: AND Nvl(prl.cancel_flag,'N') = 'N'

Line 213: from po_requisition_lines prl

209: WHERE /*nvl(PRH.TRANSFERRED_TO_OE_FLAG,'N') = 'N' AND Bug 7699084*/
210: PRH.AUTHORIZATION_STATUS = 'APPROVED'
211: AND PRH.REQUISITION_HEADER_ID = p_req_header_id
212: AND exists (select 'At least one inventory sourced line'
213: from po_requisition_lines prl
214: where prh.requisition_header_id =
215: prl.requisition_header_id
216: and prl.source_type_code = 'INVENTORY'
217: and Nvl(prl.transferred_to_oe_flag,'N') = 'N' /*Bug 7699084*/

Line 355: PO_REQUISITION_LINES RL,

351: PLA.SITE_USE_ID,
352: decode(l_op_unit_id, -1, NULL, l_op_unit_id) ,
353: 'ARRIVAL' --Bug 7662103:
354: FROM PO_REQUISITION_HEADERS RH,
355: PO_REQUISITION_LINES RL,
356: PO_LOCATION_ASSOCIATIONS_ALL PLA
357: WHERE RH.REQUISITION_HEADER_ID = RL.REQUISITION_HEADER_ID
358: AND RL.DELIVER_TO_LOCATION_ID = PLA.LOCATION_ID
359: AND nvl(PLA.ORG_ID,-1) = l_op_unit_id

Line 387: FROM PO_REQUISITION_LINES RL,

383: -- the sold to org column in the actions interface
384: Begin
385: SELECT PLA.CUSTOMER_ID
386: INTO l_customer_id
387: FROM PO_REQUISITION_LINES RL,
388: PO_LOCATION_ASSOCIATIONS_ALL PLA
389: WHERE RL.DELIVER_TO_LOCATION_ID = PLA.LOCATION_ID
390: AND nvl(PLA.ORG_ID,-1) = l_op_unit_id
391: AND RL.REQUISITION_LINE_ID = l_req_line_id;

Line 450: FROM po_requisition_lines PRL, po_req_distributions PRD

446: l_task_id,
447: l_dest_secondary_quantity ,
448: l_dest_secondary_unit ,
449: l_item_id
450: FROM po_requisition_lines PRL, po_req_distributions PRD
451: WHERE PRL.requisition_line_id = l_req_line_id
452: AND PRL.requisition_line_id = PRD.requisition_line_id; -- JOIN
453:
454: -- Note: Internal lines can only have one distribution. This

Line 604: FROM po_requisition_lines rl

600: SELECT rl.unit_price,
601: rl.unit_price
602: INTO l_unit_selling_price,
603: l_unit_list_price
604: FROM po_requisition_lines rl
605: WHERE requisition_line_id = l_req_line_id;
606:
607: ELSE
608: -- if the source and destination org currencies are not same, then populate the

Line 638: FROM po_requisition_lines rl

634: SELECT rl.unit_price/l_rate,
635: rl.unit_price/l_rate
636: INTO l_unit_selling_price,
637: l_unit_list_price
638: FROM po_requisition_lines rl
639: WHERE requisition_line_id = l_req_line_id;
640:
641:
642: END IF; -- source_curr = dest_curr

Line 739: FROM PO_REQUISITION_LINES RL,

735: l_source_secondary_uom, --MUM1.UOM_CODE,
736: round( l_source_secondary_quantity,9), --RL.SECONDARY_QUANTITY,
737: decode(si.grade_control_flag,'Y',RL.preferred_grade,NULL) -- RL.PREFERRED_GRADE
738: , decode(RL.URGENT_FLAG,'Y', fnd_profile.value('POR_URGENT_FLAG_SHIPMENT_PRIORITY_CODE'),null)
739: FROM PO_REQUISITION_LINES RL,
740: PO_REQUISITION_HEADERS RH,
741: PO_REQ_DISTRIBUTIONS RD, --only one distribution allowed!
742: MTL_SYSTEM_ITEMS SI,
743: PO_LOCATION_ASSOCIATIONS_ALL LA,

Line 776: UPDATE po_requisition_lines prl

772: --Bug7699084 Update the transferred to oe flag of the corresponding line too
773:
774: FOR i IN 1..l_req_hdr_id_tbl.Count
775: LOOP
776: UPDATE po_requisition_lines prl
777: SET prl.transferred_to_oe_flag =
778: (SELECT prh.transferred_to_oe_flag
779: FROM po_requisition_headers prh
780: WHERE prh.requisition_header_id = l_req_hdr_id_tbl(i)