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 72: l_dest_type_code PO_REQUISITION_LINES.destination_type_code%TYPE;

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

Line 73: l_source_org_id PO_REQUISITION_LINES.source_organization_id%TYPE;

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

Line 74: l_need_by_date PO_REQUISITION_LINES.need_by_date%TYPE;

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

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

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

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

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

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

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

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

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

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

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

Line 108: from po_requisition_lines lin,

104: CURSOR REQ_LINES IS
105: select nvl(org.operating_unit,-1),
106: hdr.requisition_header_id,
107: lin.requisition_line_id
108: from po_requisition_lines lin,
109: po_requisition_headers hdr,
110: org_organization_definitions org
111: where lin.requisition_header_id = hdr.requisition_header_id
112: and lin.source_organization_id = org.organization_id

Line 146: from po_requisition_lines prl

142: SET PRH.TRANSFERRED_TO_OE_FLAG = 'I'
143: WHERE nvl(PRH.TRANSFERRED_TO_OE_FLAG,'N') = 'N'
144: AND PRH.AUTHORIZATION_STATUS = 'APPROVED'
145: AND exists (select /*+ HASH_SJ */ 'At least one inventory sourced line'
146: from po_requisition_lines prl
147: where prh.requisition_header_id =
148: prl.requisition_header_id
149: and prl.source_type_code = 'INVENTORY'
150: and nvl(prl.cancel_flag,'N') = 'N'

Line 163: from po_requisition_lines prl

159: WHERE nvl(PRH.TRANSFERRED_TO_OE_FLAG,'N') = 'N'
160: AND PRH.AUTHORIZATION_STATUS = 'APPROVED'
161: AND PRH.REQUISITION_HEADER_ID = p_req_header_id
162: AND exists (select 'At least one inventory sourced line'
163: from po_requisition_lines prl
164: where prh.requisition_header_id =
165: prl.requisition_header_id
166: and prl.source_type_code = 'INVENTORY'
167: and nvl(prl.cancel_flag,'N') = 'N'

Line 291: PO_REQUISITION_LINES RL,

287: PLA.SITE_USE_ID,
288: decode(l_op_unit_id, -1, NULL, l_op_unit_id) ,
289: 'ARRIVAL' --Bug 7662103:
290: FROM PO_REQUISITION_HEADERS RH,
291: PO_REQUISITION_LINES RL,
292: PO_LOCATION_ASSOCIATIONS_ALL PLA
293: WHERE RH.REQUISITION_HEADER_ID = RL.REQUISITION_HEADER_ID
294: AND RL.DELIVER_TO_LOCATION_ID = PLA.LOCATION_ID
295: AND nvl(PLA.ORG_ID,-1) = l_op_unit_id

Line 321: FROM PO_REQUISITION_LINES RL,

317: -- the sold to org column in the actions interface
318: Begin
319: SELECT PLA.CUSTOMER_ID
320: INTO l_customer_id
321: FROM PO_REQUISITION_LINES RL,
322: PO_LOCATION_ASSOCIATIONS_ALL PLA
323: WHERE RL.DELIVER_TO_LOCATION_ID = PLA.LOCATION_ID
324: AND nvl(PLA.ORG_ID,-1) = l_op_unit_id
325: AND RL.REQUISITION_LINE_ID = l_req_line_id;

Line 382: FROM po_requisition_lines PRL, po_req_distributions PRD

378: l_task_id,
379: l_dest_secondary_quantity ,
380: l_dest_secondary_unit ,
381: l_item_id
382: FROM po_requisition_lines PRL, po_req_distributions PRD
383: WHERE PRL.requisition_line_id = l_req_line_id
384: AND PRL.requisition_line_id = PRD.requisition_line_id; -- JOIN
385:
386: -- Note: Internal lines can only have one distribution. This

Line 607: FROM PO_REQUISITION_LINES RL,

603: l_source_secondary_uom, --MUM1.UOM_CODE,
604: l_source_secondary_quantity, --RL.SECONDARY_QUANTITY,
605: decode(si.grade_control_flag,'Y',RL.preferred_grade,NULL) -- RL.PREFERRED_GRADE
606: , decode(RL.URGENT_FLAG,'Y', fnd_profile.value('POR_URGENT_FLAG_SHIPMENT_PRIORITY_CODE'),null)
607: FROM PO_REQUISITION_LINES RL,
608: PO_REQUISITION_HEADERS RH,
609: PO_REQ_DISTRIBUTIONS RD, --only one distribution allowed!
610: MTL_SYSTEM_ITEMS SI,
611: PO_LOCATION_ASSOCIATIONS_ALL LA,