DBA Data[Home] [Help]

APPS.OKS_IBINT_PUB dependencies on OKC_K_PARTY_ROLES_B

Line 1265: ,OKC_K_PARTY_ROLES_B PARTY

1261: ,OKS_K_HEADERS_B KS
1262: ,OKC_K_LINES_V KL
1263: ,OKS_K_LINES_B OKL
1264: ,OKC_STATUSES_B ST
1265: ,OKC_K_PARTY_ROLES_B PARTY
1266: , OKC_K_LINES_B OL
1267: ,OKS_K_LINES_B KSL
1268: ,OKC_K_ITEMS KIS
1269: , OKS_INSTANCE_TEMP tmp

Line 1374: ,OKC_K_PARTY_ROLES_B PARTY

1370: , OKC_STATUSES_B ST
1371: , OKS_INSTANCE_TEMP tmp
1372: , OKC_K_LINES_B TL
1373: ,OKC_K_ITEMS KIS
1374: ,OKC_K_PARTY_ROLES_B PARTY
1375: Where tmp.trm = 'Y'
1376: And KI.Object1_id1 = to_char(tmp.old_customer_product_id)
1377: And KI.Jtot_Object1_code = 'OKX_CUSTPROD'
1378: And KI.dnz_chr_id = KH.ID

Line 1478: ,OKC_K_PARTY_ROLES_B PARTY

1474: ,OKC_STATUSES_B ST
1475: ,csi_counter_associations CTRASC
1476: ,OKS_INSTANCE_TEMP tmp
1477: ,OKC_K_ITEMS KIS
1478: ,OKC_K_PARTY_ROLES_B PARTY
1479: Where tmp.trm = 'Y'
1480: And KI.object1_id1 = TO_CHAR (CTRASC.Counter_id)
1481: And ctrasc.source_object_id = tmp.old_customer_product_id
1482: And ctrAsc.source_object_code = 'CP'

Line 1577: ,OKC_K_PARTY_ROLES_B PARTY

1573: , OKC_STATUSES_B ST
1574: , OKS_INSTANCE_TEMP tmp
1575: , OKC_K_LINES_B TL
1576: ,OKC_K_ITEMS KIS
1577: ,OKC_K_PARTY_ROLES_B PARTY
1578:
1579: Where tmp.ret = 'Y'
1580: And KI.Object1_id1 = to_char(tmp.old_customer_product_id)
1581: And KI.Jtot_Object1_code = 'OKX_CUSTPROD'

Line 1680: ,OKC_K_PARTY_ROLES_B PARTY

1676: ,OKC_STATUSES_B ST
1677: ,csi_counter_associations CTRASC
1678: , OKS_INSTANCE_TEMP tmp
1679: ,OKC_K_ITEMS KIS
1680: ,OKC_K_PARTY_ROLES_B PARTY
1681:
1682: Where tmp.ret = 'Y'
1683: And KI.object1_id1 = to_char(CTRASC.Counter_id)
1684: And ctrasc.source_object_id = tmp.old_customer_product_id

Line 3534: OKC_K_PARTY_ROLES_B k_party,

3530: SELECT 'Y'
3531: FROM CSI_ITEM_INSTANCES CII,
3532: CSI_I_ORG_ASSIGNMENTS CIOA,
3533: OE_ORDER_LINES_ALL OOL,
3534: OKC_K_PARTY_ROLES_B k_party,
3535: okc_k_headers_all_b okh
3536: WHERE CII.last_oe_order_line_id = OOL.line_id( + )
3537: AND CII.instance_id = CIOA.instance_id( + )
3538: AND CIOA.relationship_type_code ( + ) = 'SOLD_FROM'