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.CSD_UPDATE_PROGRAMS_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 60: requisition_number po_requisition_headers_all.segment1%type,

56: ro_qty csd_repairs.quantity%type,
57: ro_rcvd_qty csd_repairs.quantity_rcvd%type,
58: inventory_item_id csd_repairs.inventory_item_id%type,
59: ro_uom csd_repairs.unit_of_measure%type,
60: requisition_number po_requisition_headers_all.segment1%type,
61: ordered_quantity oe_order_lines_all.ordered_quantity%type,
62: order_number oe_order_headers_all.order_number%type
63: );
64:

Line 121: requisition_number po_requisition_headers_all.segment1%type ,

117: destination_organization_id po_requisition_lines_all.destination_organization_id%type,
118: destination_subinventory po_requisition_lines_all.destination_subinventory%type,
119: serial_number_control_code mtl_system_items.serial_number_control_code%type,
120: lot_control_code mtl_system_items.lot_control_code%type,
121: requisition_number po_requisition_headers_all.segment1%type ,
122: source_org_name hr_all_organization_units.name%type ,
123: destination_org_name hr_all_organization_units.name%type ,
124: txn_source_id mtl_txn_request_lines.txn_source_id%type
125: );

Line 3145: po_requisition_headers_all prh,

3141: oel.ordered_quantity,
3142: oeh.order_number
3143: from csd_product_transactions cpt,
3144: csd_repairs cra,
3145: po_requisition_headers_all prh,
3146: oe_order_lines_all oel,
3147: oe_order_headers_all oeh
3148: where cpt.repair_line_id = cra.repair_line_id
3149: AND cpt.req_header_id = prh.requisition_header_id

Line 3181: po_requisition_headers_all prh,

3177: oel.ordered_quantity,
3178: oeh.order_number
3179: from csd_product_transactions cpt,
3180: csd_repairs cra,
3181: po_requisition_headers_all prh,
3182: oe_order_lines_all oel,
3183: oe_order_headers_all oeh
3184: where cpt.repair_line_id = cra.repair_line_id
3185: AND cpt.req_header_id = prh.requisition_header_id

Line 3222: po_requisition_headers_all prh,

3218: mtl.lot_control_code,
3219: hao.name org_name
3220: from rcv_transactions rcv,
3221: po_requisition_lines_all prl,
3222: po_requisition_headers_all prh,
3223: mtl_system_items mtl,
3224: hr_all_organization_units hao
3225: where rcv.requisition_line_id = prl.requisition_line_id
3226: and prl.item_id = mtl.inventory_item_id

Line 3293: po_requisition_headers_all prh

3289: BEGIN
3290: select 'EXISTS'
3291: into l_dummy
3292: from oe_order_headers_all oeh,
3293: po_requisition_headers_all prh
3294: where oeh.source_document_id = prh.requisition_header_id
3295: and oeh.header_id = p_order_header_id
3296: and exists (select 'x'
3297: from csd_product_transactions cpt

Line 4559: po_requisition_headers_all prh,

4555: oel.ordered_quantity,
4556: oeh.order_number
4557: from csd_product_transactions cpt,
4558: csd_repairs cra,
4559: po_requisition_headers_all prh,
4560: oe_order_lines_all oel,
4561: oe_order_headers_all oeh
4562: where cpt.repair_line_id = cra.repair_line_id
4563: AND cpt.req_header_id = prh.requisition_header_id

Line 4595: po_requisition_headers_all prh,

4591: oel.ordered_quantity,
4592: oeh.order_number
4593: from csd_product_transactions cpt,
4594: csd_repairs cra,
4595: po_requisition_headers_all prh,
4596: oe_order_lines_all oel,
4597: oe_order_headers_all oeh
4598: where cpt.repair_line_id = cra.repair_line_id
4599: AND cpt.req_header_id = prh.requisition_header_id

Line 4638: po_requisition_headers_all prh,

4634: mtl.lot_control_code,
4635: hao.name org_name
4636: from rcv_transactions rcv,
4637: po_requisition_lines_all prl,
4638: po_requisition_headers_all prh,
4639: mtl_system_items mtl,
4640: hr_all_organization_units hao
4641: where rcv.requisition_line_id = prl.requisition_line_id
4642: and prl.item_id = mtl.inventory_item_id

Line 4709: po_requisition_headers_all prh

4705: BEGIN
4706: select 'EXISTS'
4707: into l_dummy
4708: from oe_order_headers_all oeh,
4709: po_requisition_headers_all prh
4710: where oeh.source_document_id = prh.requisition_header_id
4711: and oeh.header_id = p_order_header_id
4712: and exists (select 'x'
4713: from csd_product_transactions cpt

Line 7040: po_requisition_headers_all prh,

7036: from oe_order_lines_all oel,
7037: wsh_delivery_details dd,
7038: wsh_serial_numbers dsn,--Added to fix 3801614
7039: po_requisition_lines_all prl,
7040: po_requisition_headers_all prh,
7041: mtl_system_items mtl,
7042: hr_all_organization_units hao,
7043: hr_all_organization_units hao1,
7044: mtl_txn_request_lines trl

Line 7097: po_requisition_headers_all prh,

7093: from oe_order_lines_all oel,
7094: wsh_delivery_details dd,
7095: wsh_serial_numbers dsn,--Added to fix 3801614
7096: po_requisition_lines_all prl,
7097: po_requisition_headers_all prh,
7098: mtl_system_items mtl,
7099: hr_all_organization_units hao,
7100: hr_all_organization_units hao1,
7101: mtl_txn_request_lines trl

Line 7233: po_requisition_headers_all prh

7229: BEGIN
7230: select 'EXISTS'
7231: into l_dummy
7232: from oe_order_headers_all oeh,
7233: po_requisition_headers_all prh
7234: where oeh.source_document_id = prh.requisition_header_id
7235: and oeh.header_id = p_order_header_id
7236: and exists (select 'x'
7237: from csd_product_transactions cpt