[Home] [Help]
13:
14: -- If Multi Currency Option is Set to Yes then process_status_flag should be set to 'E'
15: -- Fix for bug# 3570115
16:
17: If (NVL(fnd_profile.value('QP_MULTI_CURRENCY_INSTALLED'),'N') = 'Y') THEN
18: Update qp_interface_list_headers ih
19: set (currency_header_id, process_status_flag, attribute_status)=
20: (select c.currency_header_id,
21: decode(c.currency_header_id, null, null, 'P'),
367: WHERE (c.product_attr_value IS NULL and
368: a.concatenated_segments= c.product_attr_val_disp
369: OR c.product_attr_value IS NOT NULL and
370: a.inventory_item_id = c.product_attr_value)
371: AND a.ORGANIZATION_ID = FND_PROFILE.VALUE('QP_ORGANIZATION_ID') --8402384
372: AND qipa.rowid = c.rowid
373: AND rownum <2)
374: WHERE qipa.REQUEST_ID = P_REQUEST_ID
375: AND qipa.process_status_flag = 'P' --IS NOT NULL
384: DECODE(INVENTORY_ITEM_ID, NULL,QIPA.ATTRIBUTE_STATUS||'004',QIPA.ATTRIBUTE_STATUS)
385: FROM MTL_SYSTEM_ITEMS_VL A
386: WHERE QIPA.PRODUCT_ATTR_VALUE IS NOT NULL
387: AND A.INVENTORY_ITEM_ID = QIPA.PRODUCT_ATTR_VALUE
388: AND A.ORGANIZATION_ID = FND_PROFILE.VALUE('QP_ORGANIZATION_ID')
389: AND ROWNUM < 2
390: UNION ALL
391: SELECT A.INVENTORY_ITEM_ID, DECODE(A.INVENTORY_ITEM_ID, NULL, NULL, 'P'),
392: DECODE(INVENTORY_ITEM_ID, NULL, QIPA.ATTRIBUTE_STATUS||'004',QIPA.ATTRIBUTE_STATUS)
392: DECODE(INVENTORY_ITEM_ID, NULL, QIPA.ATTRIBUTE_STATUS||'004',QIPA.ATTRIBUTE_STATUS)
393: FROM MTL_SYSTEM_ITEMS_VL A
394: WHERE QIPA.PRODUCT_ATTR_VALUE IS NULL
395: AND A.CONCATENATED_SEGMENTS=QIPA.PRODUCT_ATTR_VAL_DISP
396: AND A.ORGANIZATION_ID = FND_PROFILE.VALUE('QP_ORGANIZATION_ID')
397: AND ROWNUM < 2
398: )
399: WHERE QIPA.REQUEST_ID = P_REQUEST_ID
400: AND QIPA.PROCESS_STATUS_FLAG = 'P'