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.FLM_EKB_UNMOVED_CARDS dependencies on MTL_KANBAN_CARD_ACTIVITY

Line 142: FROM MTL_KANBAN_CARD_ACTIVITY

138: Cursor c_cards_for_ps (l_card_id number )is
139: select
140: CREATION_DATE,
141: SUPPLY_STATUS
142: FROM MTL_KANBAN_CARD_ACTIVITY
143: WHERE KANBAN_ACTIVITY_ID = ( Select MAX(KANBAN_ACTIVITY_ID)
144: from MTL_KANBAN_CARD_ACTIVITY MKCA
145: WHERE KANBAN_CARD_ID = l_card_id );
146:

Line 144: from MTL_KANBAN_CARD_ACTIVITY MKCA

140: CREATION_DATE,
141: SUPPLY_STATUS
142: FROM MTL_KANBAN_CARD_ACTIVITY
143: WHERE KANBAN_ACTIVITY_ID = ( Select MAX(KANBAN_ACTIVITY_ID)
144: from MTL_KANBAN_CARD_ACTIVITY MKCA
145: WHERE KANBAN_CARD_ID = l_card_id );
146:
147:
148: Cursor c_ps_for_org is

Line 158: MTL_KANBAN_CARD_ACTIVITY MKCA

154: MKC.KANBAN_CARD_ID,
155: MKPS.ORGANIZATION_ID,
156: MKPS.REPLENISHMENT_LEAD_TIME
157: FROM MTL_KANBAN_PULL_SEQUENCES MKPS , MTL_KANBAN_CARDS MKC,
158: MTL_KANBAN_CARD_ACTIVITY MKCA
159: where MKPS.ORGANIZATION_ID = p_organization_id
160: and MKPS.PULL_SEQUENCE_ID = MKC.PULL_SEQUENCE_ID
161: and MKPS.REPLENISHMENT_LEAD_TIME > 0
162: and MKPS.KANBAN_PLAN_ID = -1

Line 165: from MTL_KANBAN_CARD_ACTIVITY MKCA1

161: and MKPS.REPLENISHMENT_LEAD_TIME > 0
162: and MKPS.KANBAN_PLAN_ID = -1
163: and MKC.CARD_STATUS in (1,2) -- Exclude Calculation for Cancelled and Planned Cards. Bug 14311023
164: and MKCA.KANBAN_ACTIVITY_ID = ( Select MAX(MKCA1.KANBAN_ACTIVITY_ID)
165: from MTL_KANBAN_CARD_ACTIVITY MKCA1
166: WHERE MKCA1.KANBAN_CARD_ID = MKC.KANBAN_CARD_ID
167: AND MKCA1.SUPPLY_STATUS = MKC.SUPPLY_STATUS)
168: ORDER BY MKPS.PULL_SEQUENCE_ID;
169: