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.WIP_OSP_SHP_I_WF dependencies on WIP_CONSTANTS

Line 59: and wor.autocharge_type = WIP_CONSTANTS.PO_MOVE

55: and wor.wip_entity_id = we.wip_entity_id
56: and wor.organization_id = we.organization_id
57: and nvl(wor.repetitive_schedule_id, -1) = nvl(p_rep_sched_id, -1)
58: and wor.operation_seq_num = p_op_seq_num
59: and wor.autocharge_type = WIP_CONSTANTS.PO_MOVE
60: and br.resource_id = wor.resource_id
61: and br.organization_id = wor.organization_id
62: and msik2.inventory_item_id = br.purchase_item_id
63: and msik2.organization_id = br.organization_id;

Line 85: IF l_wip_entity_type = WIP_CONSTANTS.DISCRETE or

81: , itemkey => p_itemkey
82: , aname => 'ORGANIZATION_ID'
83: , avalue => p_organization_id);
84:
85: IF l_wip_entity_type = WIP_CONSTANTS.DISCRETE or
86: l_wip_entity_type = WIP_CONSTANTS.CLOSED_DISC THEN
87:
88: wf_engine.SetItemAttrText( itemtype => p_itemtype
89: , itemkey => p_itemkey

Line 86: l_wip_entity_type = WIP_CONSTANTS.CLOSED_DISC THEN

82: , aname => 'ORGANIZATION_ID'
83: , avalue => p_organization_id);
84:
85: IF l_wip_entity_type = WIP_CONSTANTS.DISCRETE or
86: l_wip_entity_type = WIP_CONSTANTS.CLOSED_DISC THEN
87:
88: wf_engine.SetItemAttrText( itemtype => p_itemtype
89: , itemkey => p_itemkey
90: , aname => 'JOB_NAME'

Line 92: elsif l_wip_entity_type = WIP_CONSTANTS.REPETITIVE THEN

88: wf_engine.SetItemAttrText( itemtype => p_itemtype
89: , itemkey => p_itemkey
90: , aname => 'JOB_NAME'
91: , avalue => l_wip_entity_name);
92: elsif l_wip_entity_type = WIP_CONSTANTS.REPETITIVE THEN
93: select wl.line_code
94: into l_line_name
95: from wip_lines wl
96: , wip_repetitive_schedules wrs

Line 196: if(fnd_profile.value('WIP_OSP_INITIATE_REQAPPR') = WIP_CONSTANTS.NO) then

192: , avalue => l_req_import);
193: /* End of Fix for bug 8919025 (FP 8850950)*/
194:
195: /*ER 4276433*/
196: if(fnd_profile.value('WIP_OSP_INITIATE_REQAPPR') = WIP_CONSTANTS.NO) then
197: l_init_reqappr := 'N';
198: else
199: l_init_reqappr := 'Y';
200: end if;

Line 583: WIP_CONSTANTS.PER_ITEM,

579: ph.approved_flag approved_flag,
580: 0 release_num,
581: decode(msi.outside_operation_uom_type,
582: 'RESOURCE', decode(wor.basis_type,
583: WIP_CONSTANTS.PER_ITEM,
584: round(pd.quantity_ordered /wor.usage_rate_or_amount,
585: WIP_CONSTANTS.INV_MAX_PRECISION),
586: round(wo.scheduled_quantity,
587: WIP_CONSTANTS.INV_MAX_PRECISION)),

Line 585: WIP_CONSTANTS.INV_MAX_PRECISION),

581: decode(msi.outside_operation_uom_type,
582: 'RESOURCE', decode(wor.basis_type,
583: WIP_CONSTANTS.PER_ITEM,
584: round(pd.quantity_ordered /wor.usage_rate_or_amount,
585: WIP_CONSTANTS.INV_MAX_PRECISION),
586: round(wo.scheduled_quantity,
587: WIP_CONSTANTS.INV_MAX_PRECISION)),
588: 'ASSEMBLY', decode(wor.basis_type,
589: WIP_CONSTANTS.PER_ITEM,

Line 587: WIP_CONSTANTS.INV_MAX_PRECISION)),

583: WIP_CONSTANTS.PER_ITEM,
584: round(pd.quantity_ordered /wor.usage_rate_or_amount,
585: WIP_CONSTANTS.INV_MAX_PRECISION),
586: round(wo.scheduled_quantity,
587: WIP_CONSTANTS.INV_MAX_PRECISION)),
588: 'ASSEMBLY', decode(wor.basis_type,
589: WIP_CONSTANTS.PER_ITEM,
590: round(pd.quantity_ordered,
591: WIP_CONSTANTS.INV_MAX_PRECISION),

Line 589: WIP_CONSTANTS.PER_ITEM,

585: WIP_CONSTANTS.INV_MAX_PRECISION),
586: round(wo.scheduled_quantity,
587: WIP_CONSTANTS.INV_MAX_PRECISION)),
588: 'ASSEMBLY', decode(wor.basis_type,
589: WIP_CONSTANTS.PER_ITEM,
590: round(pd.quantity_ordered,
591: WIP_CONSTANTS.INV_MAX_PRECISION),
592: round(wo.scheduled_quantity,
593: WIP_CONSTANTS.INV_MAX_PRECISION))) required_assy_qty

Line 591: WIP_CONSTANTS.INV_MAX_PRECISION),

587: WIP_CONSTANTS.INV_MAX_PRECISION)),
588: 'ASSEMBLY', decode(wor.basis_type,
589: WIP_CONSTANTS.PER_ITEM,
590: round(pd.quantity_ordered,
591: WIP_CONSTANTS.INV_MAX_PRECISION),
592: round(wo.scheduled_quantity,
593: WIP_CONSTANTS.INV_MAX_PRECISION))) required_assy_qty
594: from po_headers_all ph,
595: po_lines_all pl,

Line 593: WIP_CONSTANTS.INV_MAX_PRECISION))) required_assy_qty

589: WIP_CONSTANTS.PER_ITEM,
590: round(pd.quantity_ordered,
591: WIP_CONSTANTS.INV_MAX_PRECISION),
592: round(wo.scheduled_quantity,
593: WIP_CONSTANTS.INV_MAX_PRECISION))) required_assy_qty
594: from po_headers_all ph,
595: po_lines_all pl,
596: po_distributions_all pd,
597: po_vendors pv,

Line 630: and wor.autocharge_type = WIP_CONSTANTS.PO_MOVE

626: and pd.wip_resource_seq_num = wor.resource_seq_num
627: and pd.destination_organization_id = wor.organization_id
628: and (pd.wip_repetitive_schedule_id is null or
629: pd.wip_repetitive_schedule_id =wor.repetitive_schedule_id)
630: and wor.autocharge_type = WIP_CONSTANTS.PO_MOVE
631: union all
632: select ph.segment1||'-'||pr.RELEASE_NUM po_num,
633: ph.po_header_id po_header_id,
634: pd.po_distribution_id po_distribution_id,

Line 644: WIP_CONSTANTS.PER_ITEM,

640: pr.approved_flag approved_flag,
641: pr.release_num,
642: decode(msi.outside_operation_uom_type,
643: 'RESOURCE', decode(wor.basis_type,
644: WIP_CONSTANTS.PER_ITEM,
645: round(pd.quantity_ordered /wor.usage_rate_or_amount,
646: WIP_CONSTANTS.INV_MAX_PRECISION),
647: round(wo.scheduled_quantity,
648: WIP_CONSTANTS.INV_MAX_PRECISION)),

Line 646: WIP_CONSTANTS.INV_MAX_PRECISION),

642: decode(msi.outside_operation_uom_type,
643: 'RESOURCE', decode(wor.basis_type,
644: WIP_CONSTANTS.PER_ITEM,
645: round(pd.quantity_ordered /wor.usage_rate_or_amount,
646: WIP_CONSTANTS.INV_MAX_PRECISION),
647: round(wo.scheduled_quantity,
648: WIP_CONSTANTS.INV_MAX_PRECISION)),
649: 'ASSEMBLY', decode(wor.basis_type,
650: WIP_CONSTANTS.PER_ITEM,

Line 648: WIP_CONSTANTS.INV_MAX_PRECISION)),

644: WIP_CONSTANTS.PER_ITEM,
645: round(pd.quantity_ordered /wor.usage_rate_or_amount,
646: WIP_CONSTANTS.INV_MAX_PRECISION),
647: round(wo.scheduled_quantity,
648: WIP_CONSTANTS.INV_MAX_PRECISION)),
649: 'ASSEMBLY', decode(wor.basis_type,
650: WIP_CONSTANTS.PER_ITEM,
651: round(pd.quantity_ordered,
652: WIP_CONSTANTS.INV_MAX_PRECISION),

Line 650: WIP_CONSTANTS.PER_ITEM,

646: WIP_CONSTANTS.INV_MAX_PRECISION),
647: round(wo.scheduled_quantity,
648: WIP_CONSTANTS.INV_MAX_PRECISION)),
649: 'ASSEMBLY', decode(wor.basis_type,
650: WIP_CONSTANTS.PER_ITEM,
651: round(pd.quantity_ordered,
652: WIP_CONSTANTS.INV_MAX_PRECISION),
653: round(wo.scheduled_quantity,
654: WIP_CONSTANTS.INV_MAX_PRECISION))) required_assy_qty

Line 652: WIP_CONSTANTS.INV_MAX_PRECISION),

648: WIP_CONSTANTS.INV_MAX_PRECISION)),
649: 'ASSEMBLY', decode(wor.basis_type,
650: WIP_CONSTANTS.PER_ITEM,
651: round(pd.quantity_ordered,
652: WIP_CONSTANTS.INV_MAX_PRECISION),
653: round(wo.scheduled_quantity,
654: WIP_CONSTANTS.INV_MAX_PRECISION))) required_assy_qty
655: from po_releases_all pr,
656: po_headers_all ph,

Line 654: WIP_CONSTANTS.INV_MAX_PRECISION))) required_assy_qty

650: WIP_CONSTANTS.PER_ITEM,
651: round(pd.quantity_ordered,
652: WIP_CONSTANTS.INV_MAX_PRECISION),
653: round(wo.scheduled_quantity,
654: WIP_CONSTANTS.INV_MAX_PRECISION))) required_assy_qty
655: from po_releases_all pr,
656: po_headers_all ph,
657: po_lines_all pl,
658: po_line_locations_all ps,

Line 695: and wor.autocharge_type = WIP_CONSTANTS.PO_MOVE;

691: and pd.wip_resource_seq_num = wor.resource_seq_num
692: and pd.destination_organization_id = wor.organization_id
693: and (pd.wip_repetitive_schedule_id is null or
694: pd.wip_repetitive_schedule_id =wor.repetitive_schedule_id)
695: and wor.autocharge_type = WIP_CONSTANTS.PO_MOVE;
696:
697: cursor cget_reqs (l_wip_entity_id number,
698: l_rep_sched_id number,
699: l_osp_operation_num number

Line 1688: IF(fnd_profile.value('WIP_OSP_INITIATE_REQAPPR') = WIP_CONSTANTS.NO) then

1684: itemkey,
1685: 'REQ_GROUP_BY');
1686:
1687: /*ER 4276433*/
1688: IF(fnd_profile.value('WIP_OSP_INITIATE_REQAPPR') = WIP_CONSTANTS.NO) then
1689: l_init_reqappr := 'N';
1690: ELSE
1691: l_init_reqappr := 'Y';
1692: END IF;